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 select...
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)