Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Dynamic visual legend

Hello  Is their a way to do a lengend with a values that come from a slicer. ? I used a SELECTEDVALUE on a calculated column but it is not refreshed :/
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hello v-frfei-msft 

Thank you for your response, can you send a pbix example.?

I didn't understand the first step, My fact table is huge. Could this work without afecting the performance ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    v-frfei-msft 

    My problem is different : the value of the slicer is an element of the legend 
    This is my fact table : 



    I need to create a column on the fact table that represent the legend, here is the formula:

    Legend = if('fact1 table'[month] =SELECTEDVALUE(slicer[Colonne 1]) ; 'fact1 table'[month] ;  "Other" )

    The problem is that selectedvalue does not refresh the calculated colum. so the legend does not change when I change the slicer.

    He is the report: