Cross month week, cross quarter month hierarchy in chart

[h_l]

Hello,

I just found when I expand down by date hierarchy, the cross month week, or cross quarter month will be displayed as 2 bar series.

Seemed it is because there is "month" above "weekNum" hierarchy, so, when it breaks down to weekNum level cross 2 months, the bar chart will be 2 bars as well.

But the problem is, if I don't give "month" above "weekNum", then when I drill up on the bar chart, the visual will not be summarized at "month" level.

Is there a solution can resolve this and keeping the chart is able to be drill up / expand?

Expected result:

When expand to "Week Number", the highlighted 2 data will be sum togehter to "Wk6", but not 2021-1-1-wk6 AND 2021-1-2-wk6.

then when I click "drill up" action on the chart, the data can be sum to "2021-1-1" and "2020-1-2" (Year-Quarter-Month)

Thanks.

H

[v-alq-msft · Accepted solution]

Hi, @h_l 

I think it is a normal phenomenon with hierarchy. If you don't give "Month" above "Weeknum",  the visual will be summarized as " Year=>Quarter=>WeekNum" level. If you give "Month" above "Weeknum", it will continue to divide by week based on the current hierarchy.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[h_l]

Thanks @v-alq-msft , after remove "month" and "quarter" but keeping Year-Week, it is working well now.

[Greg_Deckler]

@h_l - Not certain I follow exactly. Perhaps use the double arrows to drill versus the forked arrows? Can you post sample data to recreate?

[h_l]

Hi Greg,

As a new member, I have no permission to upload a file. I paste screen captures at below.

I hope following reply can help you help me.

If I use double arrow to drill down, then it has problem at Quarter hierarchy, as you see, the data is from 2020-1-1 to 2021-2-20, then, by Quarter will not consider "Year", but summarize 2020 Jan-Mar AND 2021 Jan-Feb data to Quarter 1 (which includes 2020 Q1 and 2021 Q1 to Q1).

Seemed it is because there is "month" above "weekNum" hierarchy, so, when it breaks down to weekNum level cross 2 months, they are splited to 2 bars as in OP

But the problem is, if I don't give "month" above "weekNum", then when I drill up on the bar chart, the visual will not be summarized at "month" level.

Is there a solution can resolve this and keeping the chart is able to be drill up to Month / expand to Week?

Screen captures:

Table Date:

Table Domain:

Table Performance:

Model:

Thank you.

H