Hierarchy - Increase granularity by minutes

[gnavia]

Good morning to you all,

I run into a problem, which I can't solve, I'm taking my first steps in POWER BI, so I have little experience and inity in the tool. I am developing a data visualization tool, however at the time of loading comes a default Hierarchy of: Year, Quarter, Month, Day. However, the data that has been uploaded is every 5 minutes (much more detailed), in d/m/yyyy hh:nn. I require that the data are under the same conditions, so that I can plot and visualize it. The code: https://1drv.ms/u/s!Ah43oWs1931zuw8HatJemNhxIx94?e=UZDycW

Something like this for example:

I'm very grateful for your help.

A hug.

[amitchandak]

@gnavia , right click on date column in visualization pane make it DateTime, it should show time till minute level

[gnavia]

Hi @amitchandak don't understand how to do it. Can you explain me step by step?, I'm just learning how to use POWER BI

[Greg_Deckler · Accepted solution]

@gnavia: I did this by creating some additional columns in the table, and then I built a custom hierarchy. To create the custom hierarchy, I entered the report view, and then in the Fields area, dragged and dropped the Month column in the Year column. This creates the hiearchy and then simply drags and drops the other columns into the hierarchy.

The updated PBIX file is attached below.

[gnavia]

Thank you it has been very utlity, this is definitely the solution I was looking for

[Greg_Deckler]

@gnavia - I think that you need to use the ellipses (...) in the right-hand corner and change what you are sorting by. You are probably currently sorting by the Value and you want to sort by the date in the axis.

[gnavia]

Hello @Greg_Deckler , excellent is exactly what I was looking for. However I have a doubt, the chart is not done in order of the dates, I think it takes a random order (or I do not know what its criterion is), could you guide me how to sort it sequentially to the dates so that it is graphed in that way?

I tried, but I haven't been able to order it.

Thank you in advance