Forum Discussion

Anonymous

Not applicable

6 years ago

How to filter a legend on a visual?

Hi all, I have a visual that has 3 filter tables applied: Position, Product, and Market Type. I would like my legend to be filtered when selecting the various table filters. Is this possible?...

Icon for Post Prodigy rank

Post Prodigy

6 years ago

@helmsb One possible workaround - turn off the legend altogether. Then use a DAX formula to get the selected value for each filter condition and show it under the chart on a card.

Something like:

position selected = IF(ISBLANK(SELECTEDVALUE(YourTable[position]), "", SELECTEDVALUE(YourTable[position])

Anonymous
Not applicable
6 years ago
Interesting idea! Would i be able to somehow format the cards to be a specific color tied to the specific filter condition? Otherwise it wont be possible to know which line is which in a scenario like this:
- sanimesa
  Post Prodigy
  6 years ago
  Anonymous Not sure about this - my assumption was you are showing only one line at a time. In which case you do not need the color to distinguish.
  you may be able to set all the line colors of a particular type to a fixed color. So, assuming you have two filters and each correspond to a different color, you can probably use a fixed color on your card.
  Again, I am probably not getting your use case completely.
  - Anonymous
    Not applicable
    6 years ago
    No problem. The reason why i really like this graph is that i can look at the market type or products of all my positions on the fly. So i can look at as many lines as i would like. I can compare Energy DA prices of all my positions or RT regulation prices of 2 positions, etc.
    
    The only issue i have is the darn legend not dynamically updating to show what each line represents.

Related content