Creating tabular report with prompts

[grlakshmi1]

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

[harib]

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

[Anonymous]

@harib 

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

Thanks.

[v-haibl-msft]

@grlakshmi1

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

[grlakshmi1]

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

[v-haibl-msft · 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

[v-haibl-msft]

@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.

Best Regards,
Herbert