Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I want to create create a Waterfall Chart for the development of the customers. But the first Month and the Last Month should show the total value of Customers, the inbetween Months should show the difference to the month before.
The measure for calculating the totals is :
[# Mitglieder]= DISTINCTCOUNTNOBLANK('Historisierte Kunden'[CUSTOMERID])
And the measure for the difference is:
[Differenz] = [# Mitglieder]-CALCULATE([# Mitglieder],DATEADD(Kalender[Datum],-1,MONTH))
Here is a Screenshot of what I am trying to achieve:
-the user can select Months or fiscal years from the Date Filter
-the upper visual shows the total customers per month
-the waterfall shows the difference from the month to the month before. But this should not be for the first and the last month, there I want to show the totals like in the upper visual.
Do you have any idea how I can achieve that?
Kind Regards,
Eva
Hi, @EvaH
Given the complexity of your data, could you provide your pbix file for reference? Sensitive information can be removed in advance.
How to provide sample data in the Power BI Forum - Microsoft Power BI Community
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey _Charlotte,
sorry for my late reply, here is a sample pbix File: https://wetransfer.com/downloads/01b037069ac2495419d8507f71bbab0b20230107110454/dacadfafe2c9e681eb7a...
Kind Regards,
Eva
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
97 | |
85 | |
70 | |
67 |
User | Count |
---|---|
116 | |
109 | |
94 | |
79 | |
72 |