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.
