Forum Discussion
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
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
21 Replies
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
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.
Not sure what you mean by "hovers on top or behind", but you can determine where each visual lies (layering) using the "Bring foward" or "Send backward" in the format ribbon.
(in the image, the line graph currently "lies" in front of the bar graph. If I choose to have the bar graph at the forefront, I would set the line graph behind the bar graph using the "Send to back" option displayed)
Using these options you can set the "layer depth" of each visual within a page: those at the forefront will "cover" the ones behind and viceversa. This is not dynamic in nature, however: once set and saved, that is how it will be "layered".
I followed this solution and works perfectly for measures. Can something simlar be applied for individual results?
My visual contains cards that I would like to be blank until they select a job from a list. The visual would then show for example who the client was for that job. The card works fine in my report but when nothing is selected from the slicer it reports back the first "client" from the list and I would prefer it to be blank if possible?
Pmorg73 I am also having the same issue. Did you find solution for that. Please let me know how to overcome this issue.
