Forum Discussion
Helper VHelp with filters/slicer creation
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 |
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! 🤠Hi Tevon713 ，
Please check all the other columns in PowerQuery except the category and then unpivot the other columns.Best Regards,
Gao
Community Support TeamIf 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
4 Replies
Hi Tevon713 ，
Please check all the other columns in PowerQuery except the category and then unpivot the other columns.Best Regards,
Gao
Community Support TeamIf 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
Tevon713Thanks Anonymous. This should work.
- Daniel29195
Community Champion
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.