Interval Adjustment

[Anonymous]

Hi All, I am trying to change my interval but I am unable to resolve yet. I want to create some thing that show each Date and each date hours. Please see screen short and attached sample BP. I also attached the outcome I am looking for which is not my work but someone did. https://1drv.ms/u/s!Amna_KsW9SHfgqp3JhtxT138m2o7sg?e=Cl6d16

Expected outcome I am looking is below: ( I want to show hours for each date) like this screen

[harshnathani · Accepted solution]

Hi @Anonymous ,

Create a separate hour Table.

Then use it in the visualization

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

So far I am able to get the interval number by changing X axis into categorical from continues.

[harshnathani · Accepted solution]

Hi @Anonymous ,

Create a separate hour Table.

Then use it in the visualization

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

I solved now !

[harshnathani]

Hi @Anonymous ,

Can you share how did you do it ?

Regards,

HN

[Anonymous]

[Anonymous]

I Just very close to this I did not create Plan Depart Hours but I copy twice in axis. See below picture.

[Anonymous]

I am still looking how can I make this way for each date have hours of hours.

[harshnathani · Accepted solution]

Hi @Anonymous ,

You will need to create a separate table for the filters to be effective.

Getting your Data Model correct is very important. 

https://www.sqlbi.com/blog/marco/2017/10/02/why-data-modeling-is-important-in-powerbi/

https://radacad.com/script-for-creating-time-table-in-power-bi-with-hours-minutes-and-seconds-buckets

Regards,

HN

Regards,

HN