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

Next up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now

Reply
Syndicate_Admin
Administrator
Administrator

Bar chart by month and year

Hello Community,

I have a series of data for the year 2024 and 2025 with information for each month for each year, what I am looking for is to be able to visualize the 12 months of each year independently, that is, first the 12 months of 2024 and then the 12 months of 2025 so that I can see the continuity in the months of that information.

Today the graph is as follows:

Jprada_0-1708443106185.png

Trying the small multiples option if it separates it but you don't understand much of the information:

Jprada_1-1708443181447.png

I wish I could have a delineating bar at the bottom and move through the 24 months to see how each of the variables evolves.

Thank you.

1 REPLY 1
qqqqqwwwweeerrr
Super User
Super User

Hi @Syndicate_Admin 

 

If i am correct you porblem statment is to sort x axis based on month-year?
here i have done similar to this is only change is that in my data i have single date columns and i am using that for creating a chart 

you alos try to create similar to that it should slove your problem 

qqqqqwwwweeerrr_1-1708504848645.png

And second approach if you have only month and year column in your data then you need to create a measure as below

Column = Sheet1[year]&  "-" & Sheet1[month]
qqqqqwwwweeerrr_2-1708505369587.png

this and need to sort by the column in ascedning order. 

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem


Regards

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.