Display Multiple Years Single Chart

[jonboylib]

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.

[v-henryk-mstf · Accepted solution]

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

Dynamic axis in Power BI — DAXis. Have you ever tried to dynamically… | by Nikola Ilic | Towards Dat...

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.

[amitchandak]

@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