Forum Discussion
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 selecting "A", only show it.
However, it has been like this:
Help, please.
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.
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
5 Replies
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.
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:
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
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
