Add columns to filter slicer

[databug]

Hi everyone, I am fairly new to PowerBI and looking to add multiple columns to filter slicer and wondering how to do it. I have location column and three fleet category column with number. Can i use one filter slicer for the fleet category. like Boom/Box/Hitchkiker if someone want to filter and see one category from the slicer. I attached the screenshot for reference. Thanks

[Anonymous · Accepted solution]

Hi @databug ,

According to your description, here are my steps you can follow as a solution.

(1) My test data is the same as yours.

(2) Create a field parameter.

(3) Then the result is as follows.

Best Regards,

Neeko Tang

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

[audreygerred]

You will need to unpivot your data (you can do it in PowerQuery) so that you have a column for Location, a column for fleet category, and a column for the value. 

Location	Fleet Category	Value
St Stephen	Box/Flat	1
Charlottetown	Boom	1
Kensington	Box/Flat	1

[AmiraBedh]

Can you please share your dataset/pbix file ?