Forum Discussion

adeelnazir's avatar
adeelnazir
Icon for Helper I rankHelper I
5 years ago

Conditional 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