How to make the X axis line chart Both Continuous and Categorical

[Ibrahim_shaik]

Hi Power Bi Community,

I have date and time on the X axis line chart and from the Date Slicer i am filtering the line chart.

time is hourly timestamps my requirement in when i select more than one day the line chart should show two days complete 48 hour timestamps or three days depending on the days selected.

now when i select two days it is aggregating the values for the same timestamps of two days and displaying the graph.

Please give a solution.

Thanks & Regards,

Ibrahim

[Ibrahim_shaik]

@Uzi2019 ,

The line chart X axis should be able to switch dynamically between categorical and continuous.

[Uzi2019 · Accepted solution]

Hi @Ibrahim_shaik 
You cannot change dynamically as this is single select setting of x axis.

You can create book mark with 2 line chart one categorial and other continues. when you click on button so it shows the value/chart you want to see.

I hope this would resolved your issue!

[Ibrahim_shaik]

Hi @Uzi2019 ,

I want both in one Line Chart.

[Uzi2019]

Hi @Ibrahim_shaik 
try to take Categorial value.

I hope this resolves your issue!