Forum Discussion
Dynamic chart based in a variable selector
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!
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
3 Replies
Anonymous , Try to use field parameters https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd
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
