Help with filters/slicer creation

[Tevon713]

I have a model where as follow.  Will need to push this in a table. What the best way to transform so user can easily select the category bucket ie salary, supplies or something else in filter slicer. Let say for instance more future date with more data, user can trends out their desire expenses or category they want to see. Thank you everyone for their ideas and suggestion.

Total Exp = SUM of Salary + SUM of Supplies + SUM of Prof Services.

Year	Month	Sites	Revenue	Salary	Supplies	Prof Services	FTE Count
2024	February	Site 1	216,843	77,761	54,354	170	14
2024	February	Site 2	124,053	58,325	67,455	-	9
2024	February	Site 2	78,160	105,631	30,695	635	12
2024	February	Site 4	72,611	59,514	16,922	855	8
2024	February	Site 4	21,809	22,945	11,088	-	4

[Daniel29195 · Accepted solution]

@Tevon713 

you want to user to be able to select between, salary , supplies, ... . . in a slicer ? 

if that so, you can use field parameter feature.

if this is not what you want , please share in a visual representation . it would be helpful . 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[v-cgao-msft · Accepted solution]

Hi @Tevon713 ，

Please check all the other columns in PowerQuery except the category and then unpivot the other columns.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[Tevon713]

Thanks @v-cgao-msft. This should work.

[Daniel29195 · Accepted solution]

@Tevon713 

you want to user to be able to select between, salary , supplies, ... . . in a slicer ? 

if that so, you can use field parameter feature.

if this is not what you want , please share in a visual representation . it would be helpful . 

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠

[Tevon713]

Thanks @Daniel29195. Tried parameter it didn't change the visuals. Typically if in slicer it would filter to selected, with parameters nothing happen display every category. See below if that make sense.