Issues with Power BI's date hierarchy

EnnyKraft

New Member
Joined
Apr 16, 2020
Messages
9
Office Version
  1. 365
Platform
  1. Windows
  2. MacOS
I decided to learn Power BI. Idiot me thought it would be easy since I already am familiar with charts, Power Query and DAX funtions. :rolleyes: But for the life of me I am unable to create a date hierarchy that works. I tried switching the auto detection in the options on and off. Created the date table with CALENDAR, CALENDARAUTO, Power Query and importing from an Excel file with a dynamic range. No matter what I do, the months don't appear as subgroups to the years. I can either see the years or drill down to the months but then all the Januarys are lumped together in one number which is not what I want.
I then downloaded a file from one of Mike Girvins's great tutorials. Here's what one chart looks like when I open it:
Screenshot 2022-08-28 103620.png
But when I delete the months and then put them back without changing anything else, this is what I get:
Screenshot 2022-08-28 103703.png
Now I'm wondering whether some settings are the reason why my date hierarchy doesn't work. I got the app from the Microsoft App Store and have the newest version of Windows 10. Does anyone have an idea why this happens? Thank you!
 

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top