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

Number Formatting Issue - #,##0 ,;(#,###,) #107

Open joel-cooptimize opened 1 year ago

joel-cooptimize commented 1 year ago

This formatting is used to 1) Display a number in thousands and 2) Make +/- numbers aligned in a table.

Here's the end result of this format in a table:

image

In the waterfall chart, this only works for positive numbers. The negative number displays the entire amount.

image

Value Format on labels is set to "None".

There are probably some work-arounds that I'll explore, but wanted to log the issue since the behavior is different than standard Power BI visuals.

(PS Excellent visual. So easy!)

joel-cooptimize commented 1 year ago

I did confirm the number format "#,###,;-#,###," works.

maxanatsko commented 1 month ago

I did confirm the number format "#,###,;-#,###," works.

doesn't work for me unfortunately - dynamic formatting isn't followed by the visual. how did you solve it?