Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Conditional formatting color on x-axis label

Hi All, I'm working on bar chart with x-axis contain year & week arrangement. I want to apply some conditional formatting on x-axis label to give indication of particular week, ie. week 43 with diff...
Coloring
Conditional Formatting
powerbi
  • BeaBF's avatar
    BeaBF
    3 years ago

    Anonymous Hi! 

    There is no way you can do it, because in the axis of the chart, as in the title, you are not in the filter context, so it applies the same value to all the labels, he cannot understand the underlying value what you see. 

     

    BBF

BeaBF's avatar
BeaBF
Super User
3 years ago

Anonymous Hi! 

There is no way you can do it, because in the axis of the chart, as in the title, you are not in the filter context, so it applies the same value to all the labels, he cannot understand the underlying value what you see. 

 

BBF

JontyB's avatar
JontyB
Advocate I
3 years ago

thanks for this explanation, ive been pulling my hair our trying to work out why my axis wasnt shows the correct colour, and from your explanation i realies that i was using another table to provide the X-axis therefore my condiditonal formatiing has no idea of the value of my calculation...