Header: Show/Hide two Matrix visuals in Power BI based on Slicer selection.
I have the requirement where there are two tables, Profile Selection table and Fact Table.
The profile is used in RLS and the values for profile selections slicer includes:
Admin
Approver
Approver_SCN123
Scheduler
Etc..
The columns from the reporting fact table are added in matrix visual.
There is no direct relationship for this two tables (Profile Selection table and Reporting Table). Hence we have created a bridge table and added the relationship. . We are able to filter the data in the matrix visual.
From the report table, we have the data for a column like “Is_Exempt =1 and Is_Exempt =0”
But, there is a challenge here : whenever we select Admin profile we should get all the records (for both Is Exempt =1 and Is Exempt =0).
When the Profile is changed from Admin to Approver in the slicer we should get only “Is_Exempt =0 not for Is_Exempt =1”.
So we tried with different functions and nothing worked. So we have come up with solution to have two separate visuals, One for Admin profile and other for Approver and the other profiles.
For this we have created a measure to hide the Data (hideandShow1 = IF(SELECTEDVALUE(RPT_USER_PROFILE_SELECTION[USER_PROFILE_NAME]) in {"Admin"},1,0)) . This measure is applied on the Visual level filter.
With this approach, we are only able hide the data not with complete visual.
Can you suggest/help with a possible solution to hide the complete matrix visual as mentioned above or with the DAX without creating two visuals to get expected data in a single visual?
