Forum Discussion
batman
1 year agoHelper I
Need Help with Parameter Setup in Slicer Configuration
Hello Everyone, I've set up two parameters in our system and need help configuring them to work correctly with my slicers. Parameter 1: Allows selection between "Cars" and "Motorcycles". Parameter...
- 1 year ago
Hi batman
Here’s how to set up cascading slicers in Power BI for your scenario:
- Create a Category Table with two categories: "Cars" and "Motorcycles."
- Create a Brand table with brands for Cars and Motorcycles, and a Model table with models linked to the corresponding brands.
- Set relationships by linking the Category table to the Brand table (e.g., Cars → Car Brands) and the Brand table to the Model table (e.g., Audi → Audi A4).
- Add slicers for Category, Brand, and Model.
- Apply filters so that the Category slicer filters the Brand slicer, and the Brand slicer filters the Model slicer.
This setup ensures dynamic filtering without bi-directional relationships, making your slicers adapt seamlessly.
If the above information helps you, please give us a Kudos and marked the Accept as a solution.
Best Regards,
Community Support Team _ C Srikanth.
batman
1 year agoHelper I
Cookistador
Brands are stricly seperated, I am not including brands that do both for this example, I have diffrent data I was just usting cars and motorcycle for simplicity, I just need a paramter that has Cars and Motorcyclies when Cars are selected then my other two slicers will have the values of Cars_Brands and Car_Models.