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

Hide Zero / Blank values distorts category hierarchy #55

Open relax528 opened 3 years ago

relax528 commented 3 years ago

I added the visual with 2 value fields and 2 category fields. With Hide Zero / Blank values enabled, the first category is now mismatched with the second category field which is a complete misrepresentation of the data.

It shifts all of the second category. Original chart shows along x-axis, SubCat1a SubCat1b SubCat2c | SubCat2a SubCat2b SubCat2c Cat1 | Cat2

Once hide zero/blank is enabled, SubCat1a and SubCatb are 0, results are incorrectly shown as

SubCat2c SubCat2a SubCat2b | SubCat2c Cat1 | Cat2

It left the same number of subcategories in SubCat1 and shifted them all so now subcategories from Cat2 appear within Cat 1!

It would be greatly appreciated if this could be fixed as it's unusable in current state.

Thanks

nishantjainuk commented 3 years ago

@relax528 Would it be possible to send me a screenshot without any sensitive data? It would be easier for me if I can see the issue with the actual visual

relax528 commented 3 years ago

@nishantjainuk

A PDF is attached illustrating the issue. Thanks! SimpleWaterfallHideZeroIssue.pdf