Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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.
@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.
It has nothing to do with data drill-down.
Nesting is related to the overlapping of subcategory bars within a larger overall bar.
Oh I did not notice that, apologies.
Take a look at this:
Much closer to what I'm looking for. How is this done?
@Anonymous,
They are two Clustered Charts with same configurations.
Only difference, one has legend and the other one has none.
Then fit them together.
What do you mean by fit them together?
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 ,
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |