Forum Discussion

KMichael99's avatar
KMichael99
Frequent Visitor
2 years ago
Solved

Field Parameters Slicer

Hi, 

 

I want to create a scatterplot that has the ability to dynamically change the Y and X-axis. 

 

To do so I've created multiple field parameters, that each have several measures. I have then created a final parameter (called Dynamic Parameter) that has all these other parameter groups within it.

 

I've managed to display this across 2 slicers. The 1st slicer has the 'Dynamic Parameter', with the 2nd slicer having the 'show values of selected field' chosen. This works and the 2nd slicer changes accordingly. 

 

I then want the axis of my scattergraph to change based on the selection of the 2nd slicer. What do I put as the field for the y/x axis to make this dynamicaly change? If I have the 'Dynamic Parameter' as the field, nothing changes.

 

Is there a way to do this differently? Alternatively I've tried just adding each paramter group to one slicer (and hoping to have a heirachy), but this doesnt work. It says that I am using fields that are unsupported?

 

 

 

 

 

However, 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi, KMichael99 

    According to your description, I created the dynamic parameter implementation to dynamically change the x-axis of the scatterplot, you can refer to the following pbix file.


    RelationShip:

     

    Parameter:

    Parameter = {
    ("Director", NAMEOF('categories'[director]), 0),
    ("Manager", NAMEOF('categories'[manager]), 1)
}


    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, KMichael99 

    According to your description, I created the dynamic parameter implementation to dynamically change the x-axis of the scatterplot, you can refer to the following pbix file.


    RelationShip:

     

    Parameter:

    Parameter = {
    ("Director", NAMEOF('categories'[director]), 0),
    ("Manager", NAMEOF('categories'[manager]), 1)
}


    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum