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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.