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 .
Hi powerbiexpert22 ,
May I ask if you have gotten this issue resolved?If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.
Thank you.