Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 moment, contains only a simple table
My Paginated report is connected to a PBI dataset located in a workspace using an XMLA endpoint ( new to me seems perform better) . I have managed to add some basic filters and after a lot of trial and error I managed to creare a basic calendar style datepicker ( I still have no idea how I got it working )
My report requires multiple kinds of date filters- such as DateToday, DateYesterday, CurrentWeek, LasstMonth and MonthtoDate. How do I go about creating a dropdown button that contains these date options
For example, when the user selects datetoday, the report should show everything for Today. And if the user selects CurrentWeek, the report should return everything for the currentweek. I also want to include a customdate within this drop down which will display the datepicker I have created
Here is a screenshot of my current setup
I want to replace the Date picker in theimage above with a dropdown containing different relative date options
Any help will be much appreciated
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.
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
I came across this link to start with. How do I go about implementing it for power bi dataset source ?
https://www.sqlservercentral.com/articles/a-single-parameter-date-range-in-sql-server-reporting-serv...
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
9 | |
8 | |
5 | |
2 | |
2 |
User | Count |
---|---|
13 | |
7 | |
6 | |
2 | |
2 |