Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
mkjit256
Advocate II
Advocate II

how to autofit to width after drilling down from month to date in a clustered visual.

My problem looks to be very simple yet i am not able to solve it. 

I have a created the following clustered visual, where on the x axis i am selecting  a month date hierarchy and on the y axis a count measure

mkjit256_0-1704398188734.png

The visual display perfectly when i am viewing the month level,

mkjit256_1-1704398284080.png

 

However when i drill down to the day level, I am unable to view all the columns without scrolling to the right.

mkjit256_2-1704398321317.png

when using the hierarchy on the x-axis i don't see the X-axis Type, to set it to continous, neither on the month level nor on the Day level.

What is really puzzling is that if i replace the hierarchy by the day column on x-axis, the visual will autofit all the columns are showing correctly

mkjit256_3-1704398488226.png

 

Any suggestions are more than welcome. 
Thanks

 

3 REPLIES 3
PWBI_hjt
Frequent Visitor

I Have exactly the same problem.

Were you able to solve it or find any workaround?

I've been searching a lot for a solution for this but nothing.

 

It seems power BI is not capable of Concatenating the labels of several columns and still treat it as a continous.

amitchandak
Super User
Super User

@mkjit256 , Try if can take the axis type as continuous

 

You can reduce the minimum category width.

 

Not many option to control the scroll

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thanks for your reply @amitchandak , i have mentioned in my original post that when i am using the hierarchy, the axis Type is disappearing:

mkjit256_0-1704425799557.png

Although for the two levels, if i drag them individually to the visual, i can clearly see the Type set to continuous

mkjit256_1-1704425868635.png

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors