Forum Discussion
Nested/Grouped Horizontal Bar Chart
OK, that makes sense. However, my experience with overlayed charts has never been successful.
Inevitably, data variance over time leads to inconsistent scaling between the overlayed charts and they become visually out of sync.
Accepted solution: My solution will be the development of a custom visual to natively generate the desired graphical output.
Hi Anonymous ,
What about the clustered bar chart in power bi?
If it is convenient, could you share your data sample which could reproduce your scenario and your desired output so that we could help further on it?
Best Regards,
Cherry
The nested bar chart does not group the detailed rankings within the overall, so visually, it does not tell the desired story.
A sample of the data is:
| Team | PeriodEnding | PeriodLabel | MetricSummaryKey | MetricSummaryName | RankValueBySummary |
| Avengers | 4/28/2019 | Sprint 10.1 | OVR-01 | Overall | 17 |
| Avengers | 4/28/2019 | Sprint 10.1 | SUM-02 | Planning | 25 |
| Avengers | 4/28/2019 | Sprint 10.1 | SUM-03 | Productivity | 25 |
| Avengers | 4/28/2019 | Sprint 10.1 | SUM-01 | Quality | 24 |
| Borg | 4/28/2019 | Sprint 10.1 | OVR-01 | Overall | 12 |
| Borg | 4/28/2019 | Sprint 10.1 | SUM-02 | Planning | 29 |
| Borg | 4/28/2019 | Sprint 10.1 | SUM-03 | Productivity | 16 |
| Borg | 4/28/2019 | Sprint 10.1 | SUM-01 | Quality | 4 |
| CDM | 4/28/2019 | Sprint 10.1 | OVR-01 | Overall | 5 |
| CDM | 4/28/2019 | Sprint 10.1 | SUM-02 | Planning | 16 |
| CDM | 4/28/2019 | Sprint 10.1 | SUM-03 | Productivity | 24 |
| CDM | 4/28/2019 | Sprint 10.1 | SUM-01 | Quality | 27 |
| Core | 4/28/2019 | Sprint 10.1 | OVR-01 | Overall | 28 |
| Core | 4/28/2019 | Sprint 10.1 | SUM-02 | Planning | 17 |
| Core | 4/28/2019 | Sprint 10.1 | SUM-03 | Productivity | 22 |
| Core | 4/28/2019 | Sprint 10.1 | SUM-01 | Quality | 20 |
| Cosmos | 4/28/2019 | Sprint 10.1 | OVR-01 | Overall | 21 |
| Cosmos | 4/28/2019 | Sprint 10.1 | SUM-02 | Planning | 29 |
| Cosmos | 4/28/2019 | Sprint 10.1 | SUM-03 | Productivity | 26 |
| Cosmos | 4/28/2019 | Sprint 10.1 | SUM-01 | Quality | 28 |
| Dew | 4/28/2019 | Sprint 10.1 | OVR-01 | Overall | 29 |
| Dew | 4/28/2019 | Sprint 10.1 | SUM-02 | Planning | 26 |
| Dew | 4/28/2019 | Sprint 10.1 | SUM-03 | Productivity | 1 |
| Dew | 4/28/2019 | Sprint 10.1 | SUM-01 | Quality | 11 |
I also have available, a version with the last 2 columns unpivoted, providing a single row for each team/period with all 4 rank values.
Hi Anonymous ,
I'm a little confused about your data sample.
From your sample data, I cannot see the values in your desired output.
If it is convenient, could you share more details?
Best Regards,
Cherry
v-piga-msft That image is not a representation of my data. It is an example of the type of visual I look to create with my data.
(Larger overall ranking bar with nested subcategories and thteir respective rankings).
My data contains dynamically calculated overall rankings, plus subcategory rankings.
mussaenda This has been the closest existing visual I have been able to find. However, it does not provide the nested visualization. Additionally, I need to invert the x-axis to reflect longer bars for smaller ordinal ranking values.
I am starting to develop a custom visual to meet my needs, but it is a time-consuming process.
You can put more than one column on your axis to drill down.
If this is what you mean by nested visualization.
