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
Post PatronI 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.