Forum Discussion

Uniqueusername's avatar
Uniqueusername
Helper III
2 years ago

Dropdown filter containing relative date filters

I am very new to PBI paginated reports and still trying to get my head around a lot of features. After struggling a lot, numerous trial and error, I have a basic report running. The report, at the mo...
@PowerBI Builder Paginated Report
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Uniqueusername ,

You can create a dropdown filter containing options like DateToday, DateYesterday, CurrentWeek, LastMonth, and MonthtoDate, along with a custom date option:

Report parameters in Power BI Report Builder - Power BI | Microsoft Learn

 

How to Get Your Question Answered Quickly - Microsoft Fabric Community

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

 

  • Uniqueusername's avatar
    Uniqueusername
    Helper III
    2 years ago

    Anonymous 

    Thanks for your response. This was one of the first things I had a look at. But I don't understand how I can go about about attributing a parameter from a list of values

     

     I also created a new dataset using the "Enter Data" mode and manually entered the ranges such as Today, Yesterday, ThisWeek etc. How do I go about filtering the report based on the selection I make from the dropdown list ?

    This is the error I am getting

     

     

     

    This is how I have setup my parameter