Dynamic Legend via Slicer in Power BI live connection

[FARYAL]

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?

• @amitchandak  @MFelix @giammariam @dm-p @PijushRoy @Ashish_Mathur @Greg_Deckler @Ahmedx @Ritaf1983 @Idrissshatila 

Regards 

Faryal

[FARYAL]

@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

[Ritaf1983 · Accepted solution]

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