Forum Discussion

stribor45's avatar
stribor45
Icon for Post Prodigy rankPost Prodigy
2 years ago
Solved

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. 

 

  1. 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?
  2. 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)
  3. 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 column

    If 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-c

     

    For axis, you can play with Max area Height and font