Forum Discussion
Message Box before filtering
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
10 Replies
- parry2kSuper User
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.
- KasiopHelper II
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?
- amitchandakSuper User
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
- parry2kSuper User
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.
- KasiopHelper II
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...
- parry2kSuper User
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.
- KasiopHelper II
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
- parry2kSuper User
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.
- parry2kSuper User
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.
- KasiopHelper II
No, I am not using a Map just a card.
please share the videa so I will try your solution.
Many thanks