Forum Discussion
Bar chart with multiple x-axes OR table with bars colored using legend
Hello, I am trying to create a visual that represents the count of TRUE or FALSE (just as an example) for a particular measure, where the bars are colored based on the county.
This is what I want my final visual to look like:
NOTE: I would like up to 3 x-axes/ columns.
I have tried creating a table, where the columns are represented by bars, but I cannot figure out how to color the bars by county.
Example:
Ive also tried a stacked bar chart, but I cannot get the multiple x-axis functionality that I want (having both "Count of TRUE" and "Count of False" using the same y-axis on the bar chart).
Example:
If anyone has suggestions on how to achieve the visual, I'd be very greatful.
Thank you!
Sample table:
| Measure ID | T/F | County |
| Measure1 | TRUE | Los Angeles |
| Measure2 | TRUE | Orange |
| Measure3 | TRUE | Los Angeles |
| Measure4 | TRUE | Orange |
| Measure5 | FALSE | Los Angeles |
| Measure1 | TRUE | Orange |
| Measure2 | TRUE | Orange |
| Measure3 | FALSE | Orange |
| Measure4 | TRUE | Orange |
| Measure5 | TRUE | Los Angeles |
| Measure1 | FALSE | Los Angeles |
| Measure2 | TRUE | Los Angeles |
| Measure3 | TRUE | Los Angeles |
| Measure4 | TRUE | Los Angeles |
| Measure5 | TRUE | Orange |
Using Small Multiples. See attached.
6 Replies
- lbendlin
Super User
Like this?
- Ritaf1983
Hi wireaim
ower BI doesn't have an option for stacked micro charts. This feature is available in the paid visualizations from Inforiver:
https://www.youtube.com/watch?v=r7zQV0Oq2ag
or you can generate it using SVG, but that requires some coding knowledge.
https://adamcampbell.tech/project1.html
Moreover, it's important to note that for the purpose of comparing two values, a stacked chart is not suitable from a visual perception standpoint. When we see stacked charts, our perception is that it’s comparing parts of a whole (like a pie chart, but instead of a circular shape, we have something resembling an English cake).
Therefore, if you want to do this correctly without confusing the graph's reader, the right approach would be to separate the two values into different columns when comparing sizes.
Or To show only the part of True (percent from total )
The pbix with the example is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
