Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jonboylib
Frequent Visitor

Display Multiple Years Single Chart

See my current visualisation below.

 

chart1.png

 

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.

1 ACCEPTED SOLUTION
v-henryk-mstf
Community Support
Community Support

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.

vhenrykmstf_0-1657268312263.png

vhenrykmstf_1-1657268333906.png

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.

 

 

 

 

 

View solution in original post

2 REPLIES 2
v-henryk-mstf
Community Support
Community Support

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.

vhenrykmstf_0-1657268312263.png

vhenrykmstf_1-1657268333906.png

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
Super User
Super User

@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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.