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

yerketai's avatar
yerketai
New Member
10 months ago

Hi, thanks again for your response!

I tried both the bridge table and TREATAS workaround as you suggested, but unfortunately, I'm still not seeing any change in the conditional formatting on the Y-axis labels when selecting a value from the slicer. The color does not update based on the slicer selection.

Could you please double-check the logic or possibly provide a working sample .pbix file or mock-up that demonstrates this functionality?

Just to recap:

  • I want all categories to always remain visible on the Y-axis.

  • I want only the selected category (from a slicer tied to a disconnected ParameterTable) to appear in gray (#505050), and the rest in white.

  • No relationship exists between the slicer table and the main table.

If there's any tweak I'm missing or an alternative method you can demonstrate, it would be really helpful.

Thanks again for your support!

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