Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Dynamic slicer relationship

I would like to make a dynamic slicer for my current survey result.

For my current result, I have a bar chart like this

 

My expected result is have a dynamic slicer in order to have the corresponding bar chart. For example, I have some demographic information(e.g. gender, age,...). If I choose gender in slicer, then the bar chart can change to bar chart for gender. However, i do not have any idea how to change it, as it seem not change. How should I change for the model relationship?

 

 

Need Help
Show and Tell
Tips and Tricks

8 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    Hi,

    In my opinion, one of ways to achieve this is to use Field Parameter feature.

     

    Fields parameters in Power BI - SQLBI

     

    Please check the below picture and the attached pbix file.

    I tried to create a sample pbix file like below, and I hope the below can provide some ideas on how to create a solution for your datamodel.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

       

      I know and treid using the field parameter. But is it possible that if i select gender then i can show the percentage of gender of the option? Because I dont have any idea about sth similar to above image

      • Jihwan_Kim's avatar
        Jihwan_Kim
        Super User
        3 years ago

        Hi,

        Thank you for your message.

        I do not fully understand how your desired outcome of the visualization looks like, but I assume it looks something like below?