Forum Discussion

allondon's avatar
allondon
Frequent Visitor
1 year ago
Solved

Conditional formatting of the graph

Hi everyone,   I'd appreciate some hints (or solutions) to implement the following:   We have 2 tables with thse relevant fields: Table A: Sum_of_fail, RuleID, Dimension Table B: RuleID, Dimens...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi allondon 
    If you're still experiencing issues, please try the following steps, as they may help resolve your problem.

    1. Please keep your stacked bar chart with PASS/FAIL on the axis and Criticality in colors. then add Department into Small multiples. Power BI will create one mini chart per department, so you can easily compare PASS/FAIL by Criticality across all departments without cluttering a single chart.

     

    2. Make a hierarchy with Result on top and a dimension like Department under it. In the bar chart, you’ll first see PASS/FAIL, and then you can drill down to the department level while still keeping the Criticality colors. This way you get both the overview and the details.

    If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

    Thanks.

allondon's avatar
allondon
Frequent Visitor
1 year ago

Does this mean conditional formatting will not work for any chart type? I was trying to implement something in DAX, but no luck so far. Thank you.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
1 year ago

allondon . Conditional formatting works for a chart with One Measure and no legends. 

A stacked visual will always have a legend. 

I can create a bar visual with multiple axes and expand than and do conditional formatting using field values or rule based. 

 

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi allondon 

    Thank you for reaching out to the Microsoft Fabric Forum Community. 
    amitchandak Thanks for the inputs.

    The suggestions provided by the user are very helpful. As mentioned, Conditional formatting applies to charts that have a single measure and do not include legends.

    Did you try the user’s suggestion? Has your issue been resolved? If not, please let us know and we will be happy to assist you further.


    Thanks.