Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.