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.
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.