cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Promethes_2 Regular Visitor
Regular Visitor

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

Accepted Solutions
Highlighted
AECourtney Frequent Visitor
Frequent Visitor

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

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

 

6 REPLIES 6
AECourtney Frequent Visitor
Frequent Visitor

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

Try making the X axis categorical rather than continuous

Promethes_2 Regular Visitor
Regular Visitor

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

The X Axis is categorical:

1.png2.png

 

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

3.png4.png

 

AECourtney Frequent Visitor
Frequent Visitor

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

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? 

Promethes_2 Regular Visitor
Regular Visitor

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

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

Highlighted
AECourtney Frequent Visitor
Frequent Visitor

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

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

 

Promethes_2 Regular Visitor
Regular Visitor

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

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
Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 260 members 2,568 guests
Please welcome our newest community members: