Forum Discussion

riyajain12345's avatar
riyajain12345
Frequent Visitor
2 years ago
Solved

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 populat...
Need Help
  • samratpbi's avatar
    samratpbi
    2 years ago

    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's avatar
samratpbi
Icon for Super User rankSuper User
2 years ago

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!