cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
BSwan
Regular Visitor

Creating Different Sort Orders in Waterfall or Bar Charts based on what level is Drilled Down On

Hi PB Community,

 

Wondering if anyone is aware of a way to default the the sort order in a Waterfall/Chart/Bar/Funnel Chart depending on what level is drilled down to (besides manually adjusting the sort by clicking the elipses in the upper right corner).

 

For example, if I have some sales data in a waterfall chart with drilldown enabled. The Hierchy goes : Year --> Month --> Region --> Salesperson --> Customer.

 

Is there a way to by default, have PB sort the Year & Month levels by chronological order, and then the Region, Salesperson, & Customer by net revenue?

 

I couldn't come up with anything natively in PowerBI, perhaps a Rank DAX function could work?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Re: Creating Different Sort Orders in Waterfall or Bar Charts based on what level is Drilled Down On

Hi @BSwan,

 

The chart not support to set default sorted column currently, you can use query editor to sort these columns:

 

Based data.
 Capture1.PNG

 

Sort in query editor.
Capture2.PNG 

 

Save the change and you will find the records sorted.
 Capture3.PNG


Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

View solution in original post

5 REPLIES 5
Community Support
Community Support

Re: Creating Different Sort Orders in Waterfall or Bar Charts based on what level is Drilled Down On

Hi @BSwan,

 

The chart not support to set default sorted column currently, you can use query editor to sort these columns:

 

Based data.
 Capture1.PNG

 

Sort in query editor.
Capture2.PNG 

 

Save the change and you will find the records sorted.
 Capture3.PNG


Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

View solution in original post

Pinkybloo Helper I
Helper I

Re: Creating Different Sort Orders in Waterfall or Bar Charts based on what level is Drilled Down On

I am having this problem too but not finding this solution works for me.  

 

I have a bar chart which shows the cases due in the next 7 days sorted by date.  

 

Capture.PNG

It has a drill down which then shows who those cases are allocated to 

 

 

Capture2.PNG

 

I want to sort this level by volume whereas it's sorted by name alpha at the moment.

 

How can I acheieve this?  I data sorted by the volume measure in the table view like this suggests but it's made no difference.

 

Thanks for any help

klabir Helper V
Helper V

Re: Creating Different Sort Orders in Waterfall or Bar Charts based on what level is Drilled Down On

Hello

We created the Power BI Ultimate Waterfall Custom Visual.

It has a lot of clever functionality built-in. Like Chart orientation, small multiples, sub totals, Start value, deviation calculation and many more.

http://dataviz.boutique/2017/03/22/powerbi-ultimate-waterfall-custom-visual/

We are interested in your feedback!

Which functionality you still miss?

THX

Klaus

M8.PNG

klabir Helper V
Helper V

Re: Creating Different Sort Orders in Waterfall or Bar Charts based on what level is Drilled Down On

Hello

We created the Power BI Ultimate Waterfall Custom Visual.

It has a lot of clever functionality built-in. Like Chart orientation, small multiples, sub totals, Start value, deviation calculation and many more.

http://dataviz.boutique/2017/03/22/powerbi-ultimate-waterfall-custom-visual/

We are interested in your feedback!

Which functionality you still miss?

THX

Klaus

M8.PNG

larabraghetti Helper I
Helper I

Re: Creating Different Sort Orders in Waterfall or Bar Charts based on what level is Drilled Down On

Hi Klaus,

 

the waterfall you have developped is awsome.

It could be nice to have also a waterfall with differences.
I'll try to explain better the topic:

we need to compare two different waterfall and to see in a third waterfall the differences between the first two graph.
Is it possible?
How can do it? Could you help us?
Thank you
Best regards
Lara

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors