Forum Discussion
adeelnazir
Helper I
5 years agoConditional formatting on x-axis font color
Hi Experts,
I need to give orange color on the x-axis font for a current week except for this black color.
Highlighted x-axis font color should be yellow, all other dates should have black color.
I do write DAX for this but not working.
for testing purposes, I write this Dax
test x-axis = IF( MAX(DateDimAkraya[Week Ending]) = DATE(2021, 9, 5), 1, 0) //"9/5/2021"
you can see in the tooltip 0 and 1 would be print accurately but when I put this measure on the x-axis fx
Following are results, all x-axis changed to yellow which is wrong.
Is it something I am doing wrong or it's Power BI limitations?
Please Help
Thanks
1 Reply
- amitchandak
Super User
adeelnazir , As far as I know this work on Grand total. Means only one value willl calculated based on that complete x-axis will be colored
If you are not using legend and mutiple measure
You can refer