Forum Discussion

dpc_development's avatar
dpc_development
Helper III
4 years ago

Better spacing between columns in Column chart

I have a Stacked Column Chart with a Date Hierarchy on the X Axis. Whenever I use 'Continuous' as the X-Axis Type, and when there are two columns, they get populated on either ends. I also have similar problems when there are very few dates. It looks like the below chart.

 

The chart is spaced a lot better when in Categorical X-Axis type.

 

I'd prefer to leave it at Continuous, as when I drill down to Dates, then it doesn't try to squeeze in every single date.

 

Need Help
Tutorial Requests

8 Replies

    • dpc_development's avatar
      dpc_development
      Helper III
      4 years ago

      The Inner Padding doesn't really help, as it just makes the columns a bit wider or narrower. Also, it seems the axis on your chart is a text field and hence is automatically set as a Categorical axis.

      • Pragati11's avatar
        Pragati11
        Super User
        4 years ago

        HI dpc_development ,

         

        The axis on my chart is not TEXT, it is a DATE Hierarchy. Even on your chart if you drill-down from Year to Quarter, etc., you will get same. 🙂

        There are 2 more options on the x-axis: 

        You will have try these with different settings to get what you are looking for.

         

        Thanks,

        Pragati

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    dpc_development you need to change the x-axis type to "Categorical" from "Continuous" on the formatting pane.

     

     

    ✨ Follow us on LinkedIn

     

    Learn about conditional formatting at Microsoft Reactor

    My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

     

    • parry2k's avatar
      parry2k
      Super User
      4 years ago

      dpc_development although you already tried it, when you are using number and date columns on the x-axis and type is continuous it automatically distributes the data points in the width of the visual. I don't see there is any other way to adjust it except what Pragati11 suggested.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I managed to resolve this by placing the year under the legend and removing the year from the x axis and just using month

     

     

  • pgo's avatar
    pgo
    Frequent Visitor
    1 year ago

    Hi Guys,

    Is there another fix for this challenge while maintainig a continuous type X-Axis?

  • HarishKM's avatar
    HarishKM
    Super User
    1 year ago

    pgo Hey,
    You can try this setting in this case.

    Step 1: I will chose Categorical field then i will increase minimum category width to 115 Pixal and this will work like a charm all the time.

     



    Note : If your goal is to show continuous trends over time and the spacing is still problematic, a Line Chart might give you a clearer visual representation without worrying about column spacing. It also allows you to drill down into specific dates without causing confusion in the visual spacing.

     

    Trend over time 

     

     

    Thanks
    Harish M
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query