Forum Discussion
Tricky Waterfall visual with many breakdowns
Hi all,
I would like to find a way to simply build a waterfall to report pillars for each fiscal year and breakdown by main impacting clients year over year. Using the following metrics:
it comes pretty well:
However (belive me..) client names are not those more impacting but likely the first coming in alphabetical order (their names are all starting for 'A' or 'B'). This may be due to the fact that we have averagely 1,000 active clients each fiscal year and the system likely cannot pick the most impacting in terms of sales variance.
Any clue on how I can address the problem?
Thanks,
C.
Hi Anonymous ,
Maybe you can modify 'sort by column' property to use other column as the sort order:
Sort one column by another column in Power BI - Power BI | Microsoft Learn
However, in another document, it is mentioned that the waterfall chart does not support customized sorting for the time being. If the method in the above document cannot be tested and take effect, then this feature is not supported for the time being:
Change how a chart is sorted in a report - Power BI | Microsoft Learn
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Anonymous ,
Maybe you can modify 'sort by column' property to use other column as the sort order:
Sort one column by another column in Power BI - Power BI | Microsoft Learn
However, in another document, it is mentioned that the waterfall chart does not support customized sorting for the time being. If the method in the above document cannot be tested and take effect, then this feature is not supported for the time being:
Change how a chart is sorted in a report - Power BI | Microsoft Learn
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.