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

Hi everyone,

 

Thanks for your help.

 

So far, it has not been possible to implement as desired: count by dimension by criticality. It may be possible using DAX.

 

The compromised solution is to have counts by criticality using different colours:

If there is a way to further split by dimension - this will satisfy the original requirement.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi allondon 
    As you said that your issue has a practical solution. We will review your another request and try to provide a solution.
    Thanks.

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi allondon 

      Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.