Forum Discussion
BI101
2 years agoRegular Visitor
stacked column chart - graphing multiple years
Hi, I'm looking to graph box count data by month versus a previous year. My data goes back multiple years but only looking to go back 1 year. Any ideas on how to do this and the best graph to us...
- Anonymous2 years ago
Hi BI101
You can refer to the following sample.
Sample data
Create a measure
MEASURE = VAR a = MAXX ( ALLSELECTED ( 'Table' ), YEAR ( [Date] ) ) VAR b = a - 1 RETURN CALCULATE ( COUNTROWS ( 'Table' ), OR ( YEAR ( 'Table'[Date] ) = a, YEAR ( 'Table'[Date] ) = b ) )Then put the measure and related value to visual.
Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ashish_Mathur
Super User
2 years agoHi,
Share the download link of the PBI file.