Dynamic Legend via Slicer with Option of All Average

[Anonymous]

Hi everyone, 

I am trying to find a solution to dynamically change the legends on a bar graph to either have values / averages broken down by each State in US or switch and see the average for the whole country against time. 

So far I found this solution: https://stackoverflow.com/questions/52428727/power-bi-dynamic-legend however it is only applicable for multiple countries and does not show country average in 1 line. 

Is there a work around? 

Thanks

[amitchandak · Accepted solution]

@Anonymous , Create a new table and join with a table having state, bidirectional join many to many

new state =

Union(Summarize(Table, Table[State], "All State", Max(Table[State]) ), Summarize(Table, Table[State], "All State", "All"))

Try to use this table as a slicer and legend

Modified version of this video - Single Select with Select All : https://youtu.be/plGqCEZRfXU