Dynamic chart based in a variable selector

[Anonymous]

Hi all!

I need to build a dynamic bar graph in which the legend is dynamic and is defined by the variable selected in a slicer, in this case, it could be selected to show the graph based on the following 3 values: Does anyone know if this can be done?

Thanks!

[amitchandak]

@Anonymous , Try to use field parameters https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd

[Anonymous]

Thanks a lot, but is possible to make it without parameters?

Thanks

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

Yes, you can make it without parameters but you still need to manually create a table containing the values in the slicer, then create a new measure as below and apply it to the visual.

Measure = SWITCH(MAX(Slicer[Field Name]),"Country",[Measure 1],"Product",[Measure 2],"Technology",[Measure 3])

Please check my sample file for more details.

Best Regards,
Community Support Team _ Eason