Dynamically changing the gap intervals on x axis as per slicer selection

[Curiouslearner]

Hi. I have a scenario wherein I need to change the interval gaps on x axis of a line chart based on a selection in a slicer. For ex - I have time in hours on x axis which is continuous that is 1,2 3,4 and so on. Now if I select 2 in slicer (slicer also has hour values),my x axis should show intervals separated by a gap of 2. For ex - 1,3 5,7,9 that is line chart will now show sales every 2 hours. Similarly when I select 3 in slicer, line chart should show sales per 3 hours and intervals on x axis will now be like 1,4,7,10,13 and so on. Can we achieve this in power bi using directquery mode. 

[parry2k]

@Curiouslearner question is not about import or DQ mode, the question is making sure the data is in the right shape and the proper data model is developed.

[parry2k]

@Curiouslearner if you are working against best practices and cannot improve your model, not sure if there is anything I can assist with. Maybe someone else can help you with this.

[Curiouslearner]

Can this be achieved using import mode?

[Curiouslearner]

Actually this is the requirement given to me by client. It has many restrictions.Would really appreciate and will be thankful to anyone who will be able to give a solution to this.

[parry2k]

@Curiouslearner do you have a sales by hours in your sales table? What does your current model look like? It is possible, but first need to understand what your current data looks like.

[Curiouslearner]

Tag values on y axis are all integers.

[Curiouslearner]

I just gave you an example. Here in my case it's tag values on y axis and on x axis it's timestamp which shows datetime format like 23 August 2023 21:30:00. So I was able to segregate hours and minutes from this timestamp column. There are many limitations as there is no date table only this timestamp column and due to direcquery we are not able to create columns either from power query or in power bi desktop.