Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Not applicable

extend date hierarchy year to minute (drill down)

Hi I am not familiar with Power BI. i found some question's and tried to create a hierarchy.


If I could make it like that, i think i can show the data's value Considering the date. 


my data collected every minute for 2years. It's Data type Date/Time


I want to show this data drill down year to minute considering date. but Power BI's time intelligence make date hierarchy year/quarter/month/day.

I found some solution's and add column use two Dax function 

HOUR = HOUR(MyTable[DT])

when i add this two measures to my graph, Power BI just going to add everything, ignoring the date. 


I tried to attach a picture, but it was not attached due to an HTML error. If there's anything weird, I'll explain it in more detail.

Thank you for your help.

Super User
Super User

Hello @Anonymous ,


Check this video for instructions on how to build a new hierarchy


If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.