Display a message instead of matrix when no slicer value is selected

[Anonymous]

I have a set of Slicers and a matrix chart .

My requirement is to display the matrix chart only if any of the Slicer value is selected otherwise it should display a message as "Please select any filters".

Thanks for your help in advance !

[MattAllington]

Create a measure, add it to a card, set the background to transparent, place the card over your matrix. 

The measure needs to display a result if nothing is selected in the slicers. Something like. 

Message = if(not(isfiltered(table[column])),”warning, select something”)

---

[bo_afk]

Hi @MattAllington ,

What if the slicer value is based on a measure? How do I write the formula for that?

I can't insert my measure in the "ISFILTERED" function.

Thanks

afk

[Anonymous]

thanks for the approach! I implemented it, it displayed a warning message when there was no selection. but when a slicer value is selected, the card is displaying the message as (Blank) instead of displaying the visual which is behind the card.

[MattAllington]

Sorry, I forgot about that. Just place a null thing as the alternate result, eg “”

[Anonymous]

I implemented it, but it didnt work as expected.

Please find the below eg for your reference
Formula -

Card = if(not(HASONEVALUE(Sheet1[Level 1]))||not(HASONEVALUE(Sheet1[Level 2]))||not(HASONEVALUE(Sheet1[Level 3])),"Please Select any Filter","")

Before Selection

Post Selection :

If i make the card as trasparent, then the text behind the card is shown - This is not my requirement.

Thanks for your help in advance!

Dhivya

[MattAllington · Accepted solution]

Well, you are in luck.  I have had this idea in my head for a while but never worked it out.  I decided to get it done.  You can read about how to hide visuals in Power BI by reading my article.

[Anonymous]

Thank you! The approach worked fine!