0

I have created a date hierarchy year > month > isoweek > date.

I get a problem correctly visualizing aggregates using this hierarchy. Example: when presenting revenue in a matrix using this hierarchy, I get weeknumbers that are split over different months, so I never see the correct sum on the week-level.

in this context the average isn't correctly calculated for week 9 as it is split between feb and mar

When I want to retain drilldown function, for example with a column chart, I get two columns for week 9 (see second screenshot).

enter image description here

I understand the issue for PowerBI it needs to either aggregate on month or week level and can't do both. What sort of solution should I be looking for here? Ideally when drilling down, the 'month context' in the visual can become ambiguous as I'm looking at week-numbers; the dotted line could be on the week 9 column rather than splitting week 9.

Improve this question
2
  • I think you know the reason, The solution is either display week or month. If you display them together. The week will be split. Commented Nov 25, 2024 at 10:31
  • What sort of design choices can be considered otherwise? Commented Dec 2, 2024 at 9:54
Related questions
0
PowerBI - Week Number on X-Axis
0
Month and year number from date field (To Create a reference field) Power BI
0
Different value in PowerBi chart per drillthrough level
Load 5 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.