Conditional formatting on x-axis font color

[adeelnazir]

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

[amitchandak]

@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

https://community.powerbi.com/t5/Community-Blog/Display-Label-Only-on-the-Last-Data-Point-of-the-Lin...