Forum Discussion
Display Multiple Years Single Chart
See my current visualisation below.
Is there any way I can display all the years in a single chaty, rather than in small multiples?
I know it might make the chart quite cluttered but I would like to know how to achieve this.
Hi jonboylib ,
For now, the best way to present it is by putting the year field in small multiply. Otherwise the results will be displayed in one coordinate.
Or you can try using dynamic axes to dynamically display the visuals of the corresponding year based on the date field.
Creating a Dynamic Axis in Power BI - Calculate Data
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
jonboylib , As of now with multiple measures you can not use legend.
So the option is to add Year to the axis. Expand the axis, and sort on the axis if needed.
refer for steps
Concatenate Label off : https://youtu.be/QgI0vIGIOOk
Hi jonboylib ,
For now, the best way to present it is by putting the year field in small multiply. Otherwise the results will be displayed in one coordinate.
Or you can try using dynamic axes to dynamically display the visuals of the corresponding year based on the date field.
Creating a Dynamic Axis in Power BI - Calculate Data
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
