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

Pmorg73's avatar
Pmorg73
Icon for Post Patron rankPost Patron
6 years ago

It does yes. Both measures are needed as it is two items on the report. I did select "bringto front" on the table but I dont think it matters.

 

The "Select job" measure has a value when nothing is selected and is then blank when something is then selected. The other measure is the opposite, so they swap over, showing values as soon as something is selected for the table. Note I did a measure for all items within the table that I used.

 

I will upload my file for you shortly

Anonymous's avatar
Anonymous
Not applicable
6 years ago

 

Thanks for that