Forum Discussion
How to migrating Direct Query parameter slicer and import mode date slicer?
I'm currently using mixed mode to import data from cloud database.
I get two slicers for pass the StartDate and EndDate to the query for Direct Query controlling the source date range.
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
Also , I get one native date slicer for tables in Import mode.
Since working on three slicers are too bothering when I select a new date range everytime.
I want to merge those slicers into single date slicer control both Direct Query parameters and date filtering.
2 Replies
- amitchandakSuper User
Anonymous , explore if dynamic M parameters can help
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters
- AnonymousNot applicable
Thank you for your reply.
This is the exactly same link I provided in the above. But the document didn't provide a solution for merging the mix-mode slicers