Forum Discussion

Uniqueusername's avatar
Uniqueusername
Icon for Helper III rankHelper 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
Icon for Helper III rankHelper 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