Select Grouping Variable

[Anonymous]

Is there a way to change your grouping variable by chosing from a list of options? For example: allow users to view the number of records by either age, gender or ethnicity by selecting one of the 3 options from a drop-down list.

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

If you want to dynamically change axis, I suggest you combine button and bookmark: https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

Or you can create a calculated table for all these variable and use TREATAS function to create measure. For more details ,please refer to https://www.kasperonbi.com/dynamically-switching-axis-on-visuals-with-power-bi/

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[amitchandak]

@Anonymous , are your looking for

Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M