The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi
I would like to change the background colour of Matrix visual column if the date is today and irrespective of the column as a value or not.
Please advise, appreciate your help,
Kind Regards,
Chiru
Solved! Go to Solution.
Hi @chiru5262 ,
In your scenario, conditional formatting cannot work on blank value, so we need to do this:
Sample data:
1. Create table tables.
Category = DISTINCT('Table'[Category])
Dates = CALENDAR(DATE(2020,8,1),DATE(2020,8,31))
2. Create relationships among the three tables.
3. Create a Martix visual.
4. Create a measure.
1 = IF(MAX(Dates[Date])=TODAY(),1)
5. Set conditional formatting.
We can find that when value is blank, conditonal formatting doesn't work. So, we need to put the Measure "1" to the matrix, too.
It works now. Then, we can hide this measure. Try this:
Next, we can also try to hide to column name of "Value".
In addition, regarding why we need to create another Dates table, I think this screenshot can explain:
BTW, .pbix file attached.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @chiru5262 ,
In your scenario, conditional formatting cannot work on blank value, so we need to do this:
Sample data:
1. Create table tables.
Category = DISTINCT('Table'[Category])
Dates = CALENDAR(DATE(2020,8,1),DATE(2020,8,31))
2. Create relationships among the three tables.
3. Create a Martix visual.
4. Create a measure.
1 = IF(MAX(Dates[Date])=TODAY(),1)
5. Set conditional formatting.
We can find that when value is blank, conditonal formatting doesn't work. So, we need to put the Measure "1" to the matrix, too.
It works now. Then, we can hide this measure. Try this:
Next, we can also try to hide to column name of "Value".
In addition, regarding why we need to create another Dates table, I think this screenshot can explain:
BTW, .pbix file attached.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks mate, it worked!
Hi @chiru5262
I would create a conditional column as assign it a value 1 if it is today otherwise 0.
On the matrix visual I will conditionally advance format each column. Yes, you have to do it for each column.
Did I resolve your issue? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!!
Regards,
Pranit
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Hi Pranit,
Thank you for the reply.
Appreciate if you can provide me the rule for conditional column , as I want the column background colour to be shown only for todays date with value or without value.
Regards,
Chiru
Hi @chiru5262
I would use the below for creating a column in the data section of power bi.
Did I resolve your issue? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!!
Regards,
Pranit
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
80 | |
78 | |
43 | |
37 |
User | Count |
---|---|
158 | |
111 | |
64 | |
59 | |
54 |