cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mmainza Frequent Visitor
Frequent Visitor

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 prominent instructions in the center.

 

Anyone know how the author is creating this setup? Can't figure it out.

 

http://www.timesunion.com/local/article/More-Capital-Region-students-are-qualifying-for-12497790.php

 

pbiFiltering.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
v-ljerr-msft Super Contributor
Super Contributor

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

Hi @mmainza,

 

I created a sample pbix file for your reference. Smiley Happy

 

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.

 

r2.PNGr3.PNG

 

Regards

2 REPLIES 2
v-ljerr-msft Super Contributor
Super Contributor

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

Hi @mmainza,

 

I created a sample pbix file for your reference. Smiley Happy

 

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.

 

r2.PNGr3.PNG

 

Regards

mmainza Frequent Visitor
Frequent Visitor

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

Perfect!

 

Now I have the excuse to play around with ISFILTERED. Thank you!

 

Separate question - is there a way to control hover interactions between visuals? For example, in Tableau you can set whether a viz hovers on top or behind the others? Currently, my card viz gets hidden by the line viz. Other times it doesn't, but I can't figure out why it works when it works.