Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello
I have a waterfall chart such as shown below. This is using the Simple Waterfall Chart -
I have tried and failed, is there a way to format the label numbers. I have tried DAX FORMAT for the measures but the simple waterall chart wont allow a measure with FORMAT in its code.
I would like to format the negatives with ( ) and also the first pillar with a thousand mark. The Last pillar seems to apply for some reason.
Thank you for any help.
Stuart
Thank you, I will try this and mark as solved when done.
Thanks
Stuart
Hi @StuartPQY ,
Instead of formatting the measure directly, consider creating a custom column in your data model that applies the desired formatting. This column can then be used for labels or tooltips in your visualization.
Formatted Value = IF([YourMeasure] < 0, "(" & FORMAT(ABS([YourMeasure]), "0,000") & ")", FORMAT([YourMeasure], "0,000"))
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
90 | |
89 | |
79 | |
70 | |
68 |
User | Count |
---|---|
226 | |
129 | |
120 | |
84 | |
78 |