1 filter for multiple columns of a report

[Anonymous]

Hi,

I have two columns i.e Work Item Type and Enhancements (Calculated Column) in my dataset with different values.

Is it possible that I can combine the two columns so as I can create 1 filter in my rport where the dropdown will show all fields eg. I name a filter ticket type and it contains: user Story, Issue, Feature, Customer Enhancement, Internal Enhancement etc.

I excel we can use "case statement and achieve this but not sure how I can do it in Power BI.

Please let me know how to proceed on this.

Regards,

Himanshu

[v-henryk-mstf · Accepted solution]

Hi @Anonymous ,

According to your requirements, I did the following test: first use duplicate to copy the same table in Power Query, and then each table retains the columns that need to be merged, use the Append function to merge them into a new table as shown in the screenshot below, and create one in the PowerBI Desktop calculate column, use the IF function to merge into a column, put the column field in the slicer, you can get the expected result, use 1 filter for multiple columns.

Column =
IF (
    'Table (5)'[Enhancements] <> BLANK (),
    'Table (5)'[Enhancements],
    'Table (5)'[Work Item Type]
)

Here is the sample pbix file.

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks it resolved my issue.

Regards,

Himanshu

[amitchandak]

@Anonymous , Check if you looking for this

https://community.powerbi.com/t5/Desktop/Once-Slicer-for-multiple-columns/td-p/407949