Forum Discussion
Filter from 2 different columns
Hi Team, I need to create a filter from 2 different columns. I want a filter from Colum Active_Status and Inactive_Status. I need to give user a filter with Available and Not Active. IP Add...
If you only want Available and not active then create a column like this:
Status Check = SWITCH(TRUE(),
'Table'[Active_Status]="Available" && 'Table'[Inactive_Status]="Not Active","Available not active",blank())If you want Active, In Active and Available and In Active create a column like this:
Status Check = SWITCH(TRUE(),
'Table'[Active_Status]="Available" && 'Table'[Inactive_Status]="","Available",
'Table'[Active_Status]="" && 'Table'[Inactive_Status]="Not Active","Not Active",
'Table'[Active_Status]="Available" && 'Table'[Inactive_Status]="Not Active","Available not active")
Hi Anonymous.
You can also try to create a measure expression to compare with selections, then you can apply this on the visual level filter to filter records.
Applying a measure filter in Power BI
Notice: you need to use unconnected table fields as the source of filter or the filter effect will apply to your records before changes.
Regards,
Xiaoxin Sheng