Cluster Column Chart to Stacked Column Chart

DAX DAX Calculations
1

Hello EDNA Forum Good Day!

Video and .pbix attached explaining what I’m trying to accomplish below:

Demo .pbix Video

PBIXDD Stacked Column Chart EDNAF.pbix (1.5 MB)

Please advise of any additional questions

Regards,

2

Hello @ambidextrousmentally,

Thank You for posting your query onto the Forum.

I’ve created 3 small measures based on the scenario suggested into the video. Below are the measures alongwith the screenshots of the final results provided for the reference -

Volume (CY) - Harsh = 
CALCULATE( SUM( PBIXDD2[usage quantity] ) , 
    'Calendar'[Year] = YEAR( TODAY() ) )



Volume (PY) - Harsh = 
CALCULATE( SUM( PBIXDD2[usage quantity] ) , 
    'Calendar'[Year] = YEAR( TODAY() ) - 1 )



Volume YoY % - Harsh = 
[Volume (CY) - Harsh]/[Volume (PY) - Harsh] -1

Final Results
Final Results1188×723 33.3 KB

I’m also attaching the working of the PBIX file for the reference purposes.

Hoping you find this useful and meets your requirements that you’ve been looking for. :slightly_smiling_face:

Thanks and Warm Regards,
Harsh

PBIXDD Stacked Column Chart EDNAF - Harsh.pbix (1.5 MB)

1 Like
3

Hello Harsh

This is exactly what I’m looking for.

Much appreciate your help and the quick turnaround!

Regards,

4

Hello @ambidextrousmentally,

You’re Welcome. :slightly_smiling_face:

I’m glad that I was able to assist you.

Thanks and Warm Regards,
Harsh