Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreNext 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
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:
Trying the small multiples option if it separates it but you don't understand much of the information:
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.
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
And second approach if you have only month and year column in your data then you need to create a measure as below
this and need to sort by the column in ascedning order.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 47 | |
| 44 | |
| 40 | |
| 18 | |
| 18 |
| User | Count |
|---|---|
| 70 | |
| 68 | |
| 33 | |
| 32 | |
| 32 |