Filter Action based on measures/values along with dimensions

Hi,
I have two visuals in a sheet. Both are based on same dataset.
First visual is a pivot table with 3 dimension fields and has several measure/value fields.
Second visual is a regular table that shows the data in tabular format.
When I click on a number on the pivot visual, I want the data in the table visual to be filtered.
I set up a Filter Action on the pivot visual. But it is passing only the dimension field values as filters to the table visual. I need the ability to filter the table visual data based on what value/measure is clicked.
Example:


When I click on any value, only D1Value, D2Value1, D3Value are being passed to the table visual. I need Value1 or Value2 also passed, these are custom calculated fields. Is it possible? If not, please let me know if a feature enhancement request is already raised.
Thanks for your help.

Hi @kborra

I don’t think this is possible. Generally, the drill kind of features are based on dimensions and not values. The filters act similar to equi join.

You should clearly articulate how the filter on the table visual should work and adk if it can be added as a feature request.

Hi @kborra,
I’ll go ahead and mark this as a feature request. Let us know if you have any additional notes to add towards the request.

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

Thank you Brett for adding this as feature request. I marked your reply as solution. This topic can be closed.

1 Like