Forum Discussion
Table Visualisations blank until something selected in a slicer
I have a slicer to filter customer names and I have a table visual which displays columns associated with the customer when nothing is selected on the slicer the table displays all the values for all...
Hi Anonymous,
Please new a measure:
Measure1 = CALCULATE ( IF ( ISFILTERED ( TB1[Customer] ), 1, 0 ), ALLSELECTED ( TB1 ) )
Add this measure to visual level filters, and set its value to 1.
Best regards,
Yuliana Gu
Hi Anonymous,
Please new a measure:
Measure1 = CALCULATE ( IF ( ISFILTERED ( TB1[Customer] ), 1, 0 ), ALLSELECTED ( TB1 ) )
Add this measure to visual level filters, and set its value to 1.
Best regards,
Yuliana Gu
Thank you v-yulgu-msft
Thanks v-yulgu-msft , this solution works, however it seems to have an unintended consequence. When I click on an item in the list filtered by the suggested measure, it blanks out the list I've just clicked on. Is that supposed to happen? Is there a way around that?
Enable Drillthrough on the filtered table, but don't specify any drillthrough columns.
Beautiful 👍
Thank you
thank you so much
