Forum Discussion
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, Dimension, Criticality.
They are currently linked on RuleID and can be linked on Dimension.
The current visual represents Sum_of_fail by Dimension (something like this).
We would like to represent Criticality within each dimension (something like this):
Basically, for each record from Table A we want to get its Criticality (High, Medium, Low) from Table B by RuleID and represent the count on the graph in a different colour. It can be any type of the graph (bar chart may be the easiest) and the count per each colour (Criticality) can be diplayed anywhere in the visual. The purpose is to display how many failures within each dimension are of High Criticality together with the Total.
Thanks in advance.
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.
11 Replies
- amitchandak
Super User
allondon , In stacked visual, we can not use conditional formatting as of now.
Make sure, legend is sorted on name, and you choose static color
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
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
Thank you.
sanalyticsallondon Can you give us some dummy data along with your pbix file?? we can try from our end.
Regards,
sanalytics
Thank you. I am not allowed to share pbix with a real dataset, but here is the link to a template pbit file and sample data if this can be used.https://drive.google.com/drive/folders/1r_pvOa3YM1IBty6jw9mdKGIUSFavsvCk?usp=sharing
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.
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.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.
