Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
grlakshmi1
Regular Visitor

Creating tabular report with prompts

Prompts.PNG

How can we create a prompt page as shown above. So the report will be loaded depending upon the selected prompts.

1 ACCEPTED SOLUTION

@grlakshmi1

 

After you publish the report to Power BI Service and share the dashboard, the report viewers will also be able to filter the records using the existing filters in filter pane, but they won't be able to save the filter changes.

Reference: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-add-a-filter-to-a-report/

 

BTW, if your problem/question has been got resolved, you can accept the right answer as solution, so that others who have the same problem/question can find the solution quickly.

 

Best Regards,
Herbert

View solution in original post

6 REPLIES 6
harib
Post Patron
Post Patron

It's possible in Power BI with some workaround. We did it today. Smiley Very Happy

Anonymous
Not applicable

@harib 

What was the workaround? We're experiencing the same issue currently.

Thanks.

v-haibl-msft
Employee
Employee

@grlakshmi1

 

Does above solution help? Please let me know if you still have question about it.
 
Best Regards,
Herbert

The end user must be able to filter the records. I think the solution which you have suggested would work while developing the report.

@grlakshmi1

 

After you publish the report to Power BI Service and share the dashboard, the report viewers will also be able to filter the records using the existing filters in filter pane, but they won't be able to save the filter changes.

Reference: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-add-a-filter-to-a-report/

 

BTW, if your problem/question has been got resolved, you can accept the right answer as solution, so that others who have the same problem/question can find the solution quickly.

 

Best Regards,
Herbert

v-haibl-msft
Employee
Employee

@grlakshmi1

 

Such prompt page is not available in Power BI Desktop. But there is a similar function which can be used to filter the report. Please refer to this document: https://powerbi.microsoft.com/en-us/documentation/powerbi-service-how-to-use-a-report-filter/. After you select the columns, you can filter the columns by adding filters to the report.

 

Creating tabular report with prompts_1.jpg

 

Best Regards,
Herbert

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.