Dynamically Calculated Column as Legend based on multiple slicer selections

[Anonymous]

Hi everyone,

I need some help, I was struggling to find a way to concatenate multiple columns either in an import or direct query mode, to add it as legend in a line plot. I give you an example

I have Region, Country, Area slicers that comes from a unique table with also the indicators per days; in order to compare indicators per selection we need in case just Region is selected, the lines with legend just with Regions, but in case I select Area the legend would change based on a Region-Area column, on the other hand if I select more than one value in each three slicers , the legend will change as a concatation of these three columns. As my initial proposal was using  5 buttons and marks,but it wasn't intuitive for users.

Please let me know if there a way to do this without the use of marks and buttons, Thanks in advance.

[v-lili6-msft]

hi  @Anonymous 

It couldn't achieve that use a dynamically Calculated Column as Legend in power bi for now.

For your case, I would suggest you unpivot the Region, Country, Area columns in fact table.

https://radacad.com/pivot-and-unpivot-with-power-bi

Then you will have two columns: Attribute and Value. now drag Value into Legend and drag Attribute and Value to a slicer together as a hierarchy slicer.

Regards,

Lin

[pranit828 · Accepted solution]

HI @Anonymous

It is not possible to change the Axis based on the filter selection.

You might like to start looking into possiblity of using bookmarks. Very interesting topic.

https://www.youtube.com/watch?v=_Afcj8mT5_Q