Forum Discussion

AyaneYep's avatar
AyaneYep
Helper I
6 years ago
Solved

Area chart

Guys, I really need your help. I have to build an area chart, showing the following captions: "A", "B" and "C". When selecting "A", the options "B" and "C" still appear. I would like that when select...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

hey AyaneYep 

 

You just need to add a slicer to completely remove the other items from the visual. You can't do it using the legend in the visual: https://community.powerbi.com/t5/Desktop/Filtering-by-Legend/td-p/300393

 

You can use SELECTEDVALUE to create a dynamic slicer to filter to whatever is selected in the visual Check out the links below for help on this:

 

https://community.powerbi.com/t5/Desktop/Dynamic-Slicer-based-on-Slicer/td-p/429694

https://community.powerbi.com/t5/Desktop/dynamic-slicer-based-on-data-in-visual/td-p/517786

 

If this helps please kudo.

If this solves your problem please accept it as a solution.

  • AyaneYep's avatar
    AyaneYep
    Helper I
    6 years ago

    A, B and C are different columns. I can only add one column to the slice, even so it looks like this:

    Below is a representation of the columns:

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      Not sure about your replay. You wanted a dotted line in the area or something else. The same option is applicable if they are different columns