Forum Discussion
Swapping filter in power bi
How to create swapping filter in power bi.
Swapping filter for example i have category, subcategory ,region fields which i want to populate with profit ,as per the user selection view should populate data .
Hi, you can create a Fields Parameter which is under Modeling -> New Parameter -> Fields. you add those columns (category, subcategory ,region) in field parameter. then create a measure and choose the field to show with that. And create a slicer on the field parameter which you created ( this actually gets added autometically)
If this resolves your problem then please mark it as solution, Thanks!
4 Replies
- samratpbi
Super User
Hi, you can create a Fields Parameter which is under Modeling -> New Parameter -> Fields. you add those columns (category, subcategory ,region) in field parameter. then create a measure and choose the field to show with that. And create a slicer on the field parameter which you created ( this actually gets added autometically)
If this resolves your problem then please mark it as solution, Thanks!
samratpbi thansk alot for your help
- samratpbi
Hi,
If you click on the parameter, it opens as DAX. from there you may add new field or rename.
