search

nishantjainuk / SimpleWaterfall-PowerBI

A Power BI Visual that allows users to create simple waterfall charts just by using measures. The standard waterfall chart isn't design to create multi step waterfall and requires the underlying data to be in a particular layout. You can create multi step waterfall. This is very useful in Finance report where you need to create causal reports.
MIT License
9 stars 4 forks source link

Sort Order #16

Closed nishantjainuk closed 4 years ago

nishantjainuk commented 4 years ago

Would you be able to add a sort order by value? Currently I can only sort values by alphabetically by category

Capture

nishantjainuk commented 4 years ago

Requested by Andrew Wong

nishantjainuk commented 4 years ago

Visual now including option to sort sub-pillars

You can change the sorting from the “Chart Options” section. You have 3 options

  1. Default – users the internal model’s sort option
  2. Ascending – positive first
  3. Descending – negative first
slvaman69 commented 4 years ago

Hi Nishant,

Thanks for this functionality that I have been able to test with the dev version of your visual. I have an additional question on this topic.

Are you planning to allow sorting for another value than the category or the value? For instance, with the default PowerBI Waterfall Chart, you can add a field in the "Tooltips" section: Waterfall chart order 1

And then you are able to use the default internal model's sort option to sort by this new field: Waterfall chart order 2

Thanks a lot for your help and don't hesitate if you need additional information.

nishantjainuk commented 4 years ago

@slvaman69 Microsoft have released the updated version which has the new sort capability. You can now replace the dev version with the official version if you are using it.

Regarding the use of additional fields to sort the data, it should be possible once I add the tooltip option. I will add it in the next release.

Thanks again for your feedback and support. Keep them coming.

Nishant