Forum Discussion

mmainza's avatar
mmainza
Frequent Visitor
8 years ago
Solved

Make visual blank/display instructions until other visual selected to filter

Caught this report used by a journalist to track FRPL over time in New York.   Notice how the timeseries visual is not only blank until the other visual is selected to filter, but it displays promi...
Show and Tell
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi mmainza,

     

    I created a sample pbix file for your reference. :smileyhappy:

     

    Mainly, you'll need to use ISFILTERED function create two measures.

    Show Text = IF(ISFILTERED(Products[Category]),"","Select a category in chart above to see its trend!")
    Show Sales = IF(ISFILTERED(Products[Category]),[Total Sales])

    Then show [Show Text] on the Card visual(with Category Label Off).

     

    And show [Show Sales] on the Line Chart.

     

     

    Regards

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Can We Use the filtered measure on the card (visualization with a sum value)? I am not able to apply the filter. Can anyone please help me?