Forum Discussion
Nested/Grouped Horizontal Bar Chart
I am trying to represent an overall ranking summary with ranked sub-categories.
Is there anything like this available as a Powerr BI Visual?
Thanks in advance.
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.
13 Replies
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
