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 have tried alot but going no where. I can't use Bookmarks or page navigation.

 

I want legend to not display is nothing is selected and display if something is selected.

 

I have created a workaround on visual display by using is filtered dax and it is somewhat working but with this approach I am facing the issue if tool tip not being displayed on second visual because it is positioned after the first visual at the same spot.

 

 

 

 

 

 

Can I please have a solution?

 

Regards 

Faryal

  • 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

2 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    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