Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi ,
I am facing multiple issues where I want to confirm if we can acheive the same with Power BI or not.
1. I have a dropdown to select WTD,QTD etc as well as Manual, When user selects manual ,Date slicer has to activate and he can able to select random dates instead of WTD.QTD. How can we make a slicer activate / deactivate based on another slicer selection value say "Manual".
2.For RLS, I have multiple Pages where i cannot hide pages , and based on roles , I need to show pages only the particular roles he is assigned to. For Example : I have Sales, KPI ,Store pages in my desktop where for Role 1 , can see all pages , Role 2 can see only KPI and store etc, But I cannot hide all three pages in my report as i am applying RLS on same PBIX. Any way to handle this?
3.For RLS, I am using Slicer and on top i am placing buttons to navigate to pages , but for certain roles in my slicer, values will be less , in that case since i am using slicer in horizontal orientation , the placing of buttons is misplaced due to some of slicer values has to hide based on RLS. Any way to hide buttons and Slicer Values based on RLS. If not, what can be the alternative way to achieve this along with RLS.
Thank you very much in advance foer any suggestions i am going to get.
Go back to your report users and ask them what they want to get out of the data you are presenting to them. Based on their feedback design a solution (Power BI based or not) that helps them make their business decisions.
Don't make their life harder by implementing meaningless and distracting features like "page level security".
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |