Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi all,
I'm trying to put together a waterfall chart showing increase and decrease on the count of a binary value from a dataset. Here is an example of what the data looks like:
I Want to count all the '1' values for each month. then create a waterfall which shows the increase/decrease in '1's for each month.
Im hoping for something that looks like this:
But with count intead of dollar values.
So Far the problem I'm having is that I get a count, but the chart just shows a total for each month and lists that as each months bar, its not showing increase/decrease month by month:
I've provided some mock sample data, nothing here is confidential. If you have any ideas, help is much appreciated.
Sample_data file: https://drive.google.com/file/d/1zfg0jh0ZFc-p_b5JHG_yqLFOXKxoiQI0/view?usp=sharing
Solved! Go to Solution.
I've figured out a way to do what I want. First of all I neded to make a month column in the data.
Month = FORMAT(Data[Date], "yyyy, mmmm")
Change the format of the column to date:
Next I made a Dax code that gets previous month, and current month then calculates the difference, I needed to us parallel period for this:
Diff month-on-month =
VAR LM = CALCULATE(SUM(Data[Binary]), PARALLELPERIOD(Data[Month], -1, MONTH))
VAR CM = SUM('Data'[Binary])
RETURN
CM - LM
Since What I need to count is in binary format, I can use SUM to get only the '1's and filter out the zero values.
Next I create a waterfall, add in my month-on-month measure into the y-axis, and add in the month column into the category field. Whats important here is to make sure you aren't using the hierarchy format for the Waterfall visual:
I've figured out a way to do what I want. First of all I neded to make a month column in the data.
Month = FORMAT(Data[Date], "yyyy, mmmm")
Change the format of the column to date:
Next I made a Dax code that gets previous month, and current month then calculates the difference, I needed to us parallel period for this:
Diff month-on-month =
VAR LM = CALCULATE(SUM(Data[Binary]), PARALLELPERIOD(Data[Month], -1, MONTH))
VAR CM = SUM('Data'[Binary])
RETURN
CM - LM
Since What I need to count is in binary format, I can use SUM to get only the '1's and filter out the zero values.
Next I create a waterfall, add in my month-on-month measure into the y-axis, and add in the month column into the category field. Whats important here is to make sure you aren't using the hierarchy format for the Waterfall visual:
Hi @Natrify ,
When you calculate the first of the month, he can easily figure out the.However, the calculation of 1 for the previous month does not show up in the waterfall plot, due to the insignificant difference between the previous month and this one.
If you calculate the difference between 1 and 0 for the current month, it is calculable and shows up normally in the waterfall charts.
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.
User | Count |
---|---|
120 | |
69 | |
68 | |
57 | |
50 |
User | Count |
---|---|
176 | |
83 | |
69 | |
65 | |
54 |