Forum Discussion
How to present clustered visual
I have this chart that shows the selected time range counts and also counts for the same time for the previous year. I have some questions about how to present this chart.
- As it is based on the current time selection on the slicer this is what it looks like but when time selection changes bars and labels on the x-axis will change to accommodate the space. Is there a way to set this up so it always looks the same?
- How do I set the x-axis labels to show in chronological order rather than randomly as it is now? This data comes from my calendar table that looks like this (see below)
- Is there a way to set these labels more readable way?
Any sugestions and best practices would be much appreciated
Hi stribor45
According to questions 1 and 3 .
We don't have an option to "freeze" the form of a graph, if the QTY of bars changes it will change their size according to visual proportions, so we have to design it very accurately.For example for dates use the thinnest format mm/yy if we are talking about months like in your example.
It does not only save a place, but it is fewer pixels for the user to read, his brain will thank you ๐
By sorting chronologically you can add a column to sort with the logic:
sort month = year('calendar'[Date])*100+month('calendar'[Date])and sort the month by this columnIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
stribor45 , In Power BI, there are only a few options for x-axis labels that you can use. To correct the sirt you can sort your month-year column on another column
Mark Month Year sort as sort column of Month Year
Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")How to Create Sort Columns and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-cFor axis, you can play with Max area Height and font