Forum Discussion
Solved
Hide Visuals for Specific Users or Group
1. can i hide certain visuals for specific users or group? example i have bar chart , line chart and pie chart in one page of report. i want to show only bar chart and pie chart to finance users and...
Hi powerbiexpert22 ,
Thank you for the follow-up,I would be happy to assist you!- Create 3 measures for each visual .
ShowBarChart =
IF(
MAX(SalesData[Department]) = "Finance",
1,
0
)ShowLineChart =
IF(
MAX(SalesData[Department]) = "Marketing",
1,
0
)ShowPieChart =
IF(
MAX(SalesData[Department]) = "Finance",
1,
0
) - To control the visibility of visuals based on user roles, add the desired chart type to your report (such as a bar chart, line chart, or pie chart), then navigate to the filter pane for that visual and apply the corresponding visibility filter: for a Bar Chart, set the filter ShowBarChart = 1; for a Line Chart, use ShowLineChart = 1; and for a Pie Chart, apply ShowPieChart = 1. This ensures that each visual is only displayed when the corresponding condition is met.Refer the screenshot:
-
Create an RLS rule on UserAccess:
[UserName] = USERPRINCIPALNAME()
- Refer the screenshots below:
- Please refer the attached file.
I hope this answer resolve your query.If so,give us kudos and consider accepting it as solution.
Regards,
Pallavi.- Create 3 measures for each visual .
powerbiexpert22 create a permissions table with user roles and a ShowVisual column (1 for visible, 0 for hidden).if you already have a table then import that . Define roles in Power BI's Manage Roles and filter the permissions table accordingly. Update the ShowVisual measure to check the user’s role and apply it as a visual-level filter use USERNAME function
