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
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 479 members 4,099 guests
Please welcome our newest community members: