my filter consists different time intervals. The graph should show values based on selected time in

[balaji26]

HI guys, I have the following requirement.

I am working on power BI desktop to create a dashboard where my input is a list of time ranges with specific intervals.

consider the following time ranges and intervals

24 hours by 60 mins - this means the x-axis of the grapsh should display data for the last 24 hours at an interval of 60 mins.

24 hours by 30 mins - last 24 hours data at an interval of 30 mins

similarly,

12 hours by 30 mins

6 hours by 15 mins

28 days by 24 hours. 

the table contains a measure value as a column. And a date field (create_time). this create time should be shown in such intervals as mentioned above and corresponding measure value in a line graph. 

Please let me know how to achieve this? 

Thanks so much in advance

Balaji

[v-yulgu-msft]

Hi @balaji26,

Based on my understanding, the data table contains a date/time field called [create-time] and a measure returning corresponding values that should be displayed in chart. And the slicer filter lists all interval types (24 hours by 60 mins, 24 hours by 30 mins, etc), right? The [create-time] displayed on X-axis will be divided into different intervals based on slicer selection, right?

In my opinion, this cannot be achieved directly. Personally speaking, you might create multiple columns, one column represents 24 hours by 60 mins, one column represents 12 hours by 30 mins, etc. In other words, you need separate columns that matches each slicer item.

To dynamically change X-axis, you can refer to the solution in this thread.

Best regards,
Yuliana Gu