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! Request now

Reply
Promethes_2
Helper II
Helper II

Drill down on line and clustered column chart renders off center bars?

When I drill down from Year to Quarter on a line and clustered column chart, the bars are off center from the x axis.  Does anyone know why or how to fix this other than turning the X axis labeling off?

 

Starting at Year:

1.png

 

And then drill down into a quarter:

2.png

 

1 ACCEPTED SOLUTION

I suppose I'm unsure as to why you wish to drill down into quarters when you have the quarters already split out as clustered columns? It doesn't like when you use the same field for both an axis and a column series, if you duplicate the quarter column in a new column like Quarter2 = 'Calendar'[Quarter], and use that for the column series, it seems to work for bringing back in the total sales line. 

 

Only real solution i can think of would be to use a stacked column line chart rather than a clustered one. 

 

so instead of 

 

clustered.PNG

 

and

 

clustered drill.PNG

it's

 

stacked.PNG

and

 

stacked drill.PNG

 

View solution in original post

6 REPLIES 6
AECourtney
Regular Visitor

Try making the X axis categorical rather than continuous

The X Axis is categorical:

1.png2.png

 

And if I change to continuous it's no different:

3.png4.png

 

It seems to be giving space for the other three bars on each one, even though there isn't anything that is showing up. Likely because you have the data split into the 4 quarters on the top level and it's bringing it down to the lower level. If you removed the legend spliting the years into quarters and then drilled down, does it still do it? 

My goal is to show Sales Per Year (split by quarter)  and then drill down into Sales Per Quarter.  Apparently I must be not understanding something correctly because I am not able to use Year/Quarter in the shared axis as well as the column series.  In this example the Line value does not display if I use Year/Quarter and then Quarter in the column series.

 

2016-11-16 12_06_31-GPM - Power BI Desktop.png

 

Additionally when I drill down on a specific year with this setup, then it seems to have lost context of the year as the line value appears but as dots for all years even though the Total Sales Per Year should filter to only the current context - CALCULATE(SUM('Sales'[Amount]),ALLEXCEPT('Calendar','Calendar'[Year]))1.png

I suppose I'm unsure as to why you wish to drill down into quarters when you have the quarters already split out as clustered columns? It doesn't like when you use the same field for both an axis and a column series, if you duplicate the quarter column in a new column like Quarter2 = 'Calendar'[Quarter], and use that for the column series, it seems to work for bringing back in the total sales line. 

 

Only real solution i can think of would be to use a stacked column line chart rather than a clustered one. 

 

so instead of 

 

clustered.PNG

 

and

 

clustered drill.PNG

it's

 

stacked.PNG

and

 

stacked drill.PNG

 

I appreciate your thoughts!  I had done a stacked chart and it works but in my opinion the clustered should operate the same way. The reason I want to drill down is so that I can change context into that year on the chart rather than having to use a slicer.  This then allows me to export the specific year data rather than all years data. 

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