Message Box before filtering

[Kasiop]

Hello,

I need to your help as I am trying to add a message bow but I have no idea how it is called and how to do it.

Basically, I need to add a message that will enable the user to see the "un rgonized data" before filtering it:

When no filter is selected, I would like to have one big message box like on the picture 1 and as soon as the user select one criteria, the message box will disapear and I will be able to show the data on each box.

Does it make sens?

Many Thanks

Kasiop

[parry2k]

@Kasiop here is the link https://youtu.be/1Szb7h_3fE4

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

[Kasiop]

thanks a lot, a very good tuto!

But I think I will face some issue as I have some visuals (like simple text box or text wrapper) where I can't use conditional formating. 

Is there any way to set up automatically a card in the backward?  

[parry2k]

@Kasiop are you using a map visual? Other visuals can be controlled but the map is not possible because the map has its own background which you cannot control. Anyhow, I'm doing a video today (published tomorrow morning) and the solution will not work for the map but will work for the rest of the visuals.

[Kasiop]

No, I am not using a Map just a card.

please share the videa so I will try your solution.

Many thanks

[parry2k]

@Kasiop Interesting, I will probably do a video on this in a few days, wait until then. The blog post I have shared has all the components, you just need to tweak it but seems like you are not able to do so. 

Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

[Kasiop]

I get it, but indeed, I am block from using the central part of the screen as I am not able to click on visual ... 

anyone that a better solution?

thanks

[parry2k]

@Kasiop here is the more specific link Show or Hide a Power BI Visual Based on Selection ✅ - Excelerator BI

Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

[Kasiop]

Thanks a lot but how to make it conditional meaning when no one is clicking on the drop downlist, the message should be there and someone is clikcking on the drop downlist, the message should disapear...

[parry2k]

@Kasiop you can follow my blog post here which show the technique on how you can make it work, you can tweak it as you see fit.

Using Conditional Formatting to Display a Message Instead of a Blank Visual | PeryTUS

Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.

[amitchandak]

@Kasiop , The way is that you put a card visual with text and background as transparent. The problem is that you will not be able to click on visual behind it post that

Measure BG= if( isfiltered(Table[Col1]) || isfiltered(Table[Col2]) || isfiltered(Table[Col3]), "FFFFFF", "FFFFFF00")

Measure Font= if( isfiltered(Table[Col1]) || isfiltered(Table[Col2]) || isfiltered(Table[Col3]), "000000", "FFFFFF00")

You have use these in conditional formatting of card visual using field value option