Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
PBI_hlpr1
Resolver I
Resolver I

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:

 

PBI_hlpr1_1-1701533774180.png

 

it comes pretty well:

 

PBI_hlpr1_0-1701533586740.png

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.

 

1 ACCEPTED SOLUTION
v-junyant-msft
Community Support
Community Support

Hi @PBI_hlpr1 ,

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

vjunyantmsft_0-1701659427658.png


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.

 

View solution in original post

2 REPLIES 2
v-junyant-msft
Community Support
Community Support

Hi @PBI_hlpr1 ,

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

vjunyantmsft_0-1701659427658.png


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.

 

Hi @v-junyant-msft , I am afraid your' right and what I want to do it is not possible. I cannot use the "sort by column" proprty as the field I need to sort on (amount) it is not in the same table.

However I have switch to Simple Waterfall custom visual and it seems to work.

 

Thanks!

C.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.