Forum Discussion
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 2: Offers choices between "Car Type" and "Motorcycle Type".
Here's what I intend to achieve: Once a selection is made in Parameter 1 (e.g., Cars), I would like both slicers to adapt and display relevant options. For instance, the first slicer should show car brands (Audi, BMW, Mercedes, Lexus), and the second slicer should display specific car models (e.g., Audi A4, Audi A5, BMW X5).
I need to establish a master parameter that enables toggling between Cars and Motorcycles. This setup should dynamically update the other two parameters based on the selection.
Could anyone guide me on how to link these parameters so the slicers update accordingly?
Thanks for your assistance!
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.
6 Replies
Why are you using parameter to achieve that?
Because here it looks like cascading slicers
Why do you not create a table: With Engine type and Brand AND Brand and Model
Will you have some brands what produce Motorbike and cars ?
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.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.
Hi batman
We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please Accept as Solution to help others benefit in the community.
Thank you.If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.Hi batman
It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered?
If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.Hi batman
I wanted to follow up since I haven't heard from you in a while. Have you had a chance to try the suggested solutions?
If your issue is resolved, please consider marking the post as solved. However, if you're still facing challenges, feel free to share the details, and we'll be happy to assist you further.
Looking forward to your response!
Best Regards,
Community Support Team _ C Srikanth.
