Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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)
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/
Regards,
HN
Regards,
HN
So far I am able to get the interval number by changing X axis into categorical from continues.
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)
I solved now !
Hi @Anonymous ,
Can you share how did you do it ?
Regards,
HN
I Just very close to this I did not create Plan Depart Hours but I copy twice in axis. See below picture.
I am still looking how can I make this way for each date have hours of hours.
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/
Regards,
HN
Regards,
HN
User | Count |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |