Forum Discussion
Visuals do not filter correctly when using measures as columns
Hi,
I am having trouble with visuals and filtering when using measures as columns (between two 'table visuals')
The measures in table1 visual are correct, however when i try and click on a selectable field, it does not filter correctly in visual table2,
However, when vice versa this works correctly - e.g. i click on a row in 'visual table 2', and it filters correctly in 'visual table 1'
DAX for measures are as follows:
3 Replies
Hi mheagerty
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
I am unable to provide you with the pbix or dummy data at this stage, however please see an example below:
One of the visuals in my report counts all rows of a measure created for values 'compliant' and not compliant' in my table.
While the visual (count) works correctly, the table still shows rows with 'Compliant'. If possible, I would like to also filter those out when I 'click' on the visual for 'Not Compliant'.
I would also like the same to apply when I click on the individual counts from my top-right visual. This will count all rows that match criteria for 'Average TTP (Days)'. Each column in this visual is also a measure (-7days, -14,days, etc)Hi mheagerty ,
Thanks Ritaf1983 for the quick reply. I have some other thoughts to add:
Based on your description, you want to filter out Not Compliant rows when clicking on a card visual object, which is not possible. You can manually add the filter on the visual object filter on the right side.
For your second question, this is also due to the design.Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
