Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    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

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

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

Raymond090576's avatar
Raymond090576
Frequent Visitor
2 years ago

thank you so much