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

Incorrect Handling of Various Data Types #123

Open DishaAwtani opened 1 month ago

DishaAwtani commented 1 month ago

The waterfall chart in Power BI is experiencing issues with handling different data types such as currency, decimal numbers, percentages, and scientific notation. Eg- when attempting to change the data type to currency, the chart fails to update and display the numbers as currency values. [This is for all 3 types of charts]

Expected Behavior

Current Behavior

Possible Solution

Steps to Reproduce (for bugs)

1. 2. 3. 4.

Context

Screenshots

DishaAwtani commented 4 weeks ago

If you will open the data tab in the right, and change the format (From above- as shown in the page) for any measure which are there in the visual (For eg- i am doing it for gross margin). I changed the format to currency. So, it's not working for simple waterfall. but as you can see, it is working for other visuals (down). Screenshot 2024-06-18 163923