Forum Discussion

batman's avatar
batman
Helper I
1 year ago
Solved

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...
  • v-csrikanth's avatar
    1 year ago

    Hi batman 

    Here’s how to set up cascading slicers in Power BI for your scenario:

    1. Create a Category Table with two categories: "Cars" and "Motorcycles."
    2. Create a Brand table with brands for Cars and Motorcycles, and a Model table with models linked to the corresponding brands.
    3. 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).
    4. Add slicers for Category, Brand, and Model.
    5. 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.