Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 f...
  • v-easonf-msft's avatar
    v-easonf-msft
    4 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

 

Thanks

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    4 years ago

    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