how to optimally use date and time filtration in power BI

[Jaromir_Vacek]

Hi all,

Could anybody help me to solve my problem in Power BI? I'm the Power Bi begginer and I'm trying to find the best way how to filter the data. I have few tables with their own SQL queries(each has a timeframe) and I would like to have this time frame like a user setting parameter so the user would be able to select the data from whatever timeframe needed.

Thank you

Jaromir

[Jaromir_Vacek]

Thank you for your help. I will investigate the  Dynamic M query parameters in Power BI Desktop it's my case

[Anonymous · Accepted solution]

Hi @Jaromir_Vacek 

If your tables are all in DirectQuery mode, you can try the Dynamic M query parameters in Power BI Desktop. This is mostly close to what you want. With this feature, report users can use a slicer to switch values and pass the selected value to a binded M query parameter which is used in SQL queries to get data from data source tables. There are many articles and blogs introducing this feature, you can search them to learn more about it. 

If your tables are in Import mode, you will not be able to let report users affect the data which is brought into Power BI. You have to import all necessary data into Power BI. Then use filters and slicers in reports to filter the data to be displayed. You can hide and block some filters that you don't want users to use. To learn more about slicers and filters in Power BI, you can go to the following links:

Slicers in Power BI - Power BI | Microsoft Learn

Types of filters in Power BI reports - Power BI | Microsoft Learn

Hope this would be helpful. 

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!