Forum Discussion
Power BI - Filter Specific VIP + Show Non-VIP Together in Visuals
Hi everyone, I’m working on a Power BI dashboard where I need to handle filtering logic for two types of employees: VIP and Non-VIP. Here's my current setup: Select VIP: A slicer filter that lets ...
Create a disconnected table either in DAX or power query. Here is the DAX expression for creating a table
Disconnected Employee List = VALUES(Table[Employee Name])Add the column from this table to your Employee Name Slicer.
Create another measure
EmployeeFilter =
Var __SelectedEmployees = Values(DIsconnectedEmployeeList[Employee Name])
Var __Result = if(SelectedVale[Table[VIP Group]) = "VIP", if(SelectedValue(Table[EmployeeName]) in __SelectedEmployees, 1, 0),1)
Return __ResultAdd the above measure as visual level filter and filter condition should be 'Is 1'
Do not forget to make necessary changes to the above expressions as per the table and column names in your model.
Need a Power BI Consultation? Hire me on Upwork
Connect on LinkedIn
|
Thank you for the suggestion! It’s a great approach, but I was hoping to have two separate slicers: one specifically for selecting specific VIPs. Still, I really appreciate your help—thank you so much!