Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello,
I have a Pivot Table in Excel with a 2-level hierarchy. Imanually re-arranged the rows in the Pivot table in order to have the groups ordered by the sum of values of the first level, and then ordered by the values of the second order:
I have the same data now available in Power BI and would like to recreate this chart. I have tried two approaches, both with non-satisfactory results:
What would be the way to display my data in the same way I did with the pivot table, without using to complicated DAX?
Here is the link to get the Power BI file with dummy data:
And here is the link to get the wanted display with the same data, in Excel:
Sub Pareto Demo.xlsx
Thanks lot,
Samuel
Solved! Go to Solution.
Unfortunately, there is no straightforward method for implementing nested sorting in charts.
It might be possible to achieve this using DAX.
I've attached a link to a discussion with a solution that was proposed a few months ago.
The discussion focuses on a cluster chart, but the underlying logic is applicable.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Hi Ritaf1983,
Thanks for your answer. I have added links to the OneDrive versions of the PowerBI file and an Excel file with the example of what I want in my initial post.
Best regards,
Samuel
Unfortunately, there is no straightforward method for implementing nested sorting in charts.
It might be possible to achieve this using DAX.
I've attached a link to a discussion with a solution that was proposed a few months ago.
The discussion focuses on a cluster chart, but the underlying logic is applicable.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
User | Count |
---|---|
80 | |
77 | |
64 | |
48 | |
45 |
User | Count |
---|---|
103 | |
45 | |
39 | |
39 | |
36 |