Forum Discussion
Conditional formatting of the graph
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.
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.
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.