Forum Discussion
Conditional Formatting for Specific Column, Label (y-axis) or Date (x-axis)
Hi,
As in atthached figure, am trying to highligh the day -7 and day -14 with a differemt color in x-axis (date), in the column or in label. Although the code is working well, it is not changing the color of the specific dates for date, column or label.
I share also the code used:
ReferencePoints =
VAR _teste1 = DATEDIFF(CALCULATE(MAX('1.0_DateFilter'[Date]), ALL('1.0_DateFilter'[Date])), MAX('1.0_DateFilter'[Date]), DAY)
RETURN
SWITCH(TRUE(), _teste1 = -7, 1,
_teste1 = -14, 2,
0)
How to solve? Any other solution for this situation?
Thanks.
SQ
Thanks for Kedar_Pande and lbendlin's concern about this issue.
Hi, sergioquerido
I am glad to help you.In Power BI, we can set all X-axis values to be uniformly a certain color:
But unfortunately, it is not possible to individually display the value of an X-axis as a certain color by creating a conditional format, which is not directly supported by Power BI Desktop itself.
If you really want to display the X-axis values in a certain color, perhaps you can use it in conjunction with Table visual, something like this:
I have attached the pbix file for this small example below, I hope it helps.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Create a Measure to Identify Special Days:
Apply Conditional Formatting:
This approach should allow you to highlight those specific days with a different color.
Your Kudos/Likes are much appreciated!
If this post helps, please consider Accepting it as the solution to help the other members find it more quickly.
Regards,
Kedar Pande
www.linkedin.com/in/kedar-pandeThanks Kedar_Pande ,
The following code works with the conditional formatting for collumns and labels but not for dates in x-axis.
10.0_ReferencePoints = SWITCH(TRUE(), SELECTEDVALUE('1.0_DateFilter'[Date]) = LASTDATE(ALL('1.0_DateFilter'[Date]))-7, 1, SELECTEDVALUE('1.0_DateFilter'[Date]) = LASTDATE(ALL('1.0_DateFilter'[Date]))-14, 2, 0)
Best you can do with standard visuals is change the color of the bar. For anything else you would need custom visuals.
Thanks for Kedar_Pande and lbendlin's concern about this issue.
Hi, sergioquerido
I am glad to help you.In Power BI, we can set all X-axis values to be uniformly a certain color:
But unfortunately, it is not possible to individually display the value of an X-axis as a certain color by creating a conditional format, which is not directly supported by Power BI Desktop itself.
If you really want to display the X-axis values in a certain color, perhaps you can use it in conjunction with Table visual, something like this:
I have attached the pbix file for this small example below, I hope it helps.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
