Forum Discussion

yerketai's avatar
yerketai
New Member
10 months ago
Solved

Conditional Formatting on Y-Axis Not Responding to Slicer Selection

Hello Microsoft Support Team, I'm trying to apply conditional formatting to the Y-axis labels of a clustered bar chart in Power BI using a DAX measure like this: ColorMeasure = VAR _selected = SEL...
Need Help
  • v-achippa's avatar
    v-achippa
    10 months ago

    Hi yerketai,

     

    Thank you for reaching out to Microsoft Fabric Community.

     

    Thank you FarhanJeelani for the prompt response.

     

    Power BI currently does not support per tick conditional formatting of axis labels. Axis conditional formatting evaluates as a single value for the visual, so you can set one dynamic color for the whole axis but cannot color individual Y-axis labels based on slicer selection.

    The best approach is to color the bars or data labels instead of the axis labels, this evaluates per category and will respond to your disconnected slicer.

     

    Thanks and regards,

    Anjan Kumar Chippa

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
10 months ago

Hi yerketai,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Thank you FarhanJeelani for the prompt response.

 

Power BI currently does not support per tick conditional formatting of axis labels. Axis conditional formatting evaluates as a single value for the visual, so you can set one dynamic color for the whole axis but cannot color individual Y-axis labels based on slicer selection.

The best approach is to color the bars or data labels instead of the axis labels, this evaluates per category and will respond to your disconnected slicer.

 

Thanks and regards,

Anjan Kumar Chippa

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
10 months ago

Hi yerketai,

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa

  • v-achippa's avatar
    v-achippa
    Icon for Community Support rankCommunity Support
    10 months ago

    Hi @yerketai,

     

    We wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

     

    Thanks and regards,

    Anjan Kumar Chippa