Line Chart X axis range switch

[Ibrahim_shaik]

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.

[VillyMBI]

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. 

[Ibrahim_shaik]

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.