The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I created a report comprising of 6 pages/tabs (3 of the tabs/pages are Operational reports and the other 3 tabs/pages are Financial reports). Is there a way based on a button selection (either Operational or Financial) I can hide and show the applicable pages/tabs. That is, if Operational is selected, only the 3 Operational report tabs/pages will be displayed and the 3 Financial report tabs/pages will be hidden and vice versa? Other ideas will be appreciated.
No, this is not possible. However you can use the recently discussed RLS based page access "hack" to achieve a similar goal. For that you need to hide ALL six pages, and then have three buttons that (depending on RLS) take the user to the three operationl pages or to the three financial pages.
NOTE: This is a hack. Anyone who has the original page deep link will still be able to access the hidden pages.
A proper solution would be a separare set of apps, one app for operations, one app for finance.