Forum Discussion
waterfall chart requirement
Hi Power Folks,
I have doubt in the waterfall chart . i created the waterfall chart which is showing the month wise variance. but the problem is suppose i am comapring the month apr-23 and may-23 but i want to show the sum of apr-23 values in the apr-23 bar and may-23 values on the may-23 bar between that it shows the change in different category. but in my case may-23 showing the change in value due to changes in different category. attaching the image of the chart but my total value is below
Apr-23 2667
May-23 2613
but if you see it change the value of may-23 . i dont want that i want the total of each comaparing month and between that it shows the variance.
Please let me know if have any questions.
Best Regards,
Kaustubh
The change in the total value of May-23 in the waterfall chart is due to the inclusion of the category “Total” in the calculation.
You can try to create a new measure for the total value of the month to filter out the “Total” in the category.
Here's my example data and measure for your reference.
Total Value = CALCULATE(SUM('Example Table'[amount]), FILTER('Example Table', 'Example Table'[category] <> "Total"))Since I don't know your data, if my solution doesn't meet your requirements, please provide your template data and remember to protect data privacy.
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
The change in the total value of May-23 in the waterfall chart is due to the inclusion of the category “Total” in the calculation.
You can try to create a new measure for the total value of the month to filter out the “Total” in the category.
Here's my example data and measure for your reference.
Total Value = CALCULATE(SUM('Example Table'[amount]), FILTER('Example Table', 'Example Table'[category] <> "Total"))Since I don't know your data, if my solution doesn't meet your requirements, please provide your template data and remember to protect data privacy.
Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.