Forum Discussion
Helper IIIHow to order the breakdown in Waterfall chart
I want to sort the breakdown in the order of "New Sales", "Renewals" and "Prepayment", however the chart only allows sorting by date or Variance. Is there a way to sort by the name of the breakdown? Thanks!
14 Replies
Power BI only lets you sort by category or value (y-axis) - the breakdown is only sorted by increasing or decreasing values.
If you need the breakdown in a specific order, I would recommend using "Simple Waterfall" which is a custom visual you can download if you go to "Get more visuals" in the Visualizations pane.
There, you would put in a table with a list of your breakdown items (just the names) that is already sorted in the "Category" section.
Then put a measure in the "Values" section where it calculates the values based on the breakdown item names.
You should include the start and end pillars, and then in the visualization settings you can define which breakdownitems are your pillars.Excellent, de best component, very easy and complete. Thanks a lot!
- Fowmy
Super User
qazwsxedc
You need to add a sort column (Number Column) in the table based on your preference then sort the category based on that sort column.
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
qazwsxedcThanks! I i did created a breakdown table with the order column. Somehow the breakdown is still order by variance value.
- Fowmy
Did you try sorting it from the visual?
change the visual to a table visual and try
you may share a sample pbix file to check
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
- qazwsxedc
There is a sample file similar to mine:
https://drive.google.com/file/d/1PnVcjE-e1dGA0OnGvGOUCbQURlcNQ0rD/view?usp=sharing
I want to show the breakdown in the order of Volume, Mix, Gross Revenue, and Discounts. How to do that? Thanks!
