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

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Forum statistics

Threads
1,216,500
Messages
6,131,016
Members
449,615
Latest member
Nic0la

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