Power bi Multiple slicers effecting one table

[Anonymous]

Hi, i was wondering if its possible and whats the best way to have two slicers based on date, effecting two separate columns in a single table in powerbi. I need to have flexibility in the comparison dates so two slicer would be ideal for example one would be current week and the other previous week but in another case we could be comparing months/years. The slicer for current week would need to apply for one column then the previous week would apply to a different one then id compare the two.

Any help would be brilliant.

[v-danhe-msft]

Hi @Anonymous,

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

Regards,

Daniel He

[v-danhe-msft]

Hi @Anonymous,

Based on my research, I am afraid you could not use multiple slicers for one table, the different slicers will affect each other and could not achieve your desired result, I suggest submit an idea in ideas forum:

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Regards,

Daniel He