Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Power Bi Community,
I use line chart with timestamp and date on x axis.
I have a date filter to filter the line chart.
when i select one day it shows 24 hour timestamps which is fine.
But when i select more than 1 day that is two or three days it does not show the selected days hourly timestamps in the chart it only adds up the y axis values for the same timestamps and displays the graph for the selected number of days.
So i used drill up and then one level down hierarchy then it gives all the timestamps of each day separately but then i have to horizontally scroll which i don't want.
And then I used continuous X axis even that didn't solve when i select more than 1 day it gives only 12 AM to next day 12 AM range it want next day timestamps as well.
Please suggest a solution.
Thank you.
Hi @Ibrahim_shaik ,
It looks like you have taken the proper steps, but I would like to know how you created the DIM DATE TIME table and its relationship with your FACT table to understand your situation.
I have not created Date time table separately it's in the same table with the fields that i have used in the line chart.
User | Count |
---|---|
85 | |
72 | |
71 | |
67 | |
56 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |