The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
@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
Hi Guys,
Is there another fix for this challenge while maintainig a continuous type X-Axis?
I managed to resolve this by placing the year under the legend and removing the year from the x axis and just using month
@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.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Hi @dpc_development ,
Just use the Inner Padding option as shown in the video below:
Thanks,
Pragati
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.
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