cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DanBusIntel Member
Member

Power BI - Can I create a splash screen that will filter which report to show (see post for info)

Hi,

I would like to produce the following but require some guidance on how to do it.
I have a number of reports, these being:

1) An single, Overall Company report. This report will contain all Divisions (North, South West, South East). The data is aggregated at the Division level.
2) A Division report. This is a level below the Overall Company report and will contain the regions for each Division. For example, The Division report for 'North' will show the regions for Scotland, North East, North West, and Midlands. (a further example, the South West report will contain Wales, South, and London).

 

I can control the data to show in these reports by using Row Level Security (RLS), however I would like a way for the initial screen to show a list of check boxes, one check box for each report that user is allowed to view, so when the user clicks the check box that appears in the same screen (but to the right), at bit like the below drawing:

Mockup.jpg


So as you can see this user has the authority to view the Overall Company, North, and South East reports. The user chose North so that is the report that appeared to the right on the same screen.

So I feel there are, at least, two questions here:

1) How do I produce a check box list dynamically shows the reports the user is allowed to view?
2) How do I show that report based on which check box the user clicked?

Any guidance will be much appreciated.

Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: Power BI - Can I create a splash screen that will filter which report to show (see post for info

@DanBusIntel you can use bookmarks to achieve all this and based on your selection you can show respective bookmark page.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

1 REPLY 1
Highlighted
Super User
Super User

Re: Power BI - Can I create a splash screen that will filter which report to show (see post for info

@DanBusIntel you can use bookmarks to achieve all this and based on your selection you can show respective bookmark page.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





View solution in original post

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)