Forum Discussion

FARYAL's avatar
FARYAL
Frequent Visitor
2 years ago
Solved

Dynamic Legend via Slicer in Power BI live connection

Hello All,  I have been desperately trying to make a legend in bar chart visual since 2 weeks now. As I am working in live connection. A friend already has a solution but unwilling to share.    I ...
  • Ritaf1983's avatar
    Ritaf1983
    2 years ago

    Hi FARYAL 
    You can use a workaround by adding shape and conditional formatting.

    Create a Dax measure with the code like :

    legend_f = if (ISFILTERED('Table'[Teams]),"#FFFFFF00","#FFFFFF")
    (in your case you need the color codes of your background)
    add a small shape in place of the legend:

    switch off the border and use the Dax that we created for a fill of the shape

    result:

    Filtered:

    Pbix is attached

    If this post helps, then please consider Accepting it as the solution to help the other

    members find it more quickly

FARYAL's avatar
FARYAL
Frequent Visitor
2 years ago

Ritaf1983 Thank you for your help it worked in normal circumstances. However, with me the graphs presentation was also different. Like one was wih multiples and other were without. 

 

So to hadle the tool tip issue I actually created a page navigation with corresponding tables and used a information icon to navigate to the page and it worked for me.

 

I really appreciate your help.

 

Regards Faryal