Forum Discussion
Post PatronWaterfall Chart not showing Decreases
Hi,
I am currently using the Waterfall Chart, where I am showing Employee Headcount for the Values as per below DAX expression
Headcount =
CALCULATE(
COUNTX(
FILTER('HR','HR'[EmpStartDate]<=MAX('Dates'[Date])
&&
(ISBLANK('HR'[EmpEndDate])
|| 'HR'[EmpEndDate]>MAX(Dates[Date]))),
'HR'[EmpId])
) + 0
And for the Category I have the Year for some reason I am not seeing any descreases, it is just accumulating, if I switch to a table chart you can see the below values, where between 2019 to 2020 it descreases -150, between 2020 to 2021 it increases 150 and between 2021 to 2022 deceases -150
How do I show what it has increased or decreased over the years
Hi AvPowerBI ,
You need to add one field to the Breakdown bucket just as describe in the following official documentation.
And there is one thread which has the similar problem with you, you can review it.
Waterfall Chart Not Showing Decreases
I created a sample pbix file(see attachment) for you, please check whether that is what you want.
1. Create a calculated column as below to get the difference between current year headcount and previous year headcount
Difference = VAR _pyheadcount = CALCULATE ( [Headcount], FILTER ( ALLSELECTED ( 'Dates' ), 'Dates'[Year] = SELECTEDVALUE ( 'Dates'[Year] ) - 1 ) ) RETURN IF ( _pyheadcount = 0, BLANK (), [Headcount] - _pyheadcount )2. Add the new created calculated column to the Breakdown bucket just as below screenshot
Best Regards
1 Reply
Hi AvPowerBI ,
You need to add one field to the Breakdown bucket just as describe in the following official documentation.
And there is one thread which has the similar problem with you, you can review it.
Waterfall Chart Not Showing Decreases
I created a sample pbix file(see attachment) for you, please check whether that is what you want.
1. Create a calculated column as below to get the difference between current year headcount and previous year headcount
Difference = VAR _pyheadcount = CALCULATE ( [Headcount], FILTER ( ALLSELECTED ( 'Dates' ), 'Dates'[Year] = SELECTEDVALUE ( 'Dates'[Year] ) - 1 ) ) RETURN IF ( _pyheadcount = 0, BLANK (), [Headcount] - _pyheadcount )2. Add the new created calculated column to the Breakdown bucket just as below screenshot
Best Regards