Forum Discussion
Make visual blank/display instructions until other visual selected to filter
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
Microsoft EmployeeHi 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.
PaulDBrownCommunity Champion
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".
- Pmorg73
Post Patron
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?
