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...
  • 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.