Area chart

[AyaneYep]

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 selecting "A", only show it.

However, it has been like this:

Help, please.

[Anonymous · Accepted solution]

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.

[amitchandak]

In format, search for customize series

Choose A in series

Choose line style and switch on the marker

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[Anonymous · Accepted solution]

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]

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]

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

[Anonymous · Accepted solution]

Hey @AyaneYep 

You can create a slicer for columns. You'll just need to unpivotthe data first. Check out this thread: https://community.powerbi.com/t5/Desktop/Slicer-by-Column/td-p/111630