Forum Discussion

Ibrahim_shaik's avatar
2 years ago

Line Chart X axis range switch

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.

 

2 Replies

  • 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's avatar
      Ibrahim_shaik
      Helper V

      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.