Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
And then drill down into a quarter:
Solved! Go to 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
and
it's
and
Try making the X axis categorical rather than continuous
The X Axis is categorical:
And if I change to continuous it's no different:
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.
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]))
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
and
it's
and
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |