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

X-Axis formatting incorrect #13

Closed nishantjainuk closed 4 years ago

nishantjainuk commented 4 years ago

The visual doesn't respect field formatting of date from SSAS. In SSAS I have this formatting for date field: MMMM yyyy but in the visual I see yyyy-mm-ddThh:mm:ss waterafall_vs_barchart

ZdenekSoldan commented 4 years ago

Hi Nishant,

I tried your workaround with formating the date as text using DAX FORMAT and it works but I calculate monthly differences using DAX PREVIOUSMONTH and it needs date format. So the calculation doesn't work. Thank you very much.

nishantjainuk commented 4 years ago

@ZdenekSoldan

One option is that you create 2 measures exactly the same and use of them with the format function and in the visual and another one for the PREVIOUSMONTH calculation.

Nishant

nishantjainuk commented 4 years ago

Hi @ZdenekSoldan

I hope you are doing well. I have updated the custom visual to fix this bug. I have submitted this to Microsoft however it will take about 4 weeks for it to go live on appsource.

In the mean time, you can download the beta version of the visual from here

As I don't have the option to test it against SSAS, I would really appreciate if you could test and provide your feedback on this bug.

Nishant

ZdenekSoldan commented 4 years ago

Hi Nishant,

it works great! Thank you very much. But I also registered a new problem with labels which haven't been problematic in the old version. Now when you have selected automatic selection of label's units it looks like it takes unit from the first bar and propagated it to all others. In my case, the first bar is commonly in millions but changes could be in thousands and it shows 0M.

Thank you very much for you time and improvements! Best regards,

Zdenek

nishantjainuk commented 4 years ago

@ZdenekSoldan

Hi there,

I have updated the visual. You can download it here. Can you try again please and let me know if this has worked or not?

Thanks Nishant

ZdenekSoldan commented 4 years ago

Hi Nishant,

now it works perfectly fine! Thank you very much.

Zdenek

nishantjainuk commented 4 years ago

@ZdenekSoldan Closing this bug as this issue is fixed in version 2.10.0.1 .