Skip to main content
cancel
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

Reply
Anonymous
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.

Year-Quarter-Month-Day-Hour-Min

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])
MINUTE = MINUTE(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.

1 REPLY 1
Idrissshatila
Super User
Super User

Hello @Anonymous ,

 

Check this video for instructions on how to build a new hierarchy https://www.youtube.com/watch?v=1Y0T_KkeWyQ&t=6s

 

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

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors