Forum Discussion
Series in stacked column chart
Hello. I have a situation I hope I can get solved in this community.
There's an image attached below, this image corresponds to a stacked column chart with three series, that I'll be calling Series 1, Series 2 and Series 3. The reason why these three series are included is because chart needs to be sort in that order:
First by Series 1, then by series 2 and then by series 3.
Sort is working properly so far. What I need to do is to hide (not remove) Series 2. I tried using conditional formatting to change font color to white, and it worked, but affected all three series. Is there any way to get that specific series hidden, so only Series 1 and Series 3 appear in the dashboard.
Besides, I need gridlines to repond to Series 3 only, so there's no gridline for every single Series 2, but only the ones corresponding every single Series 3.
I'd really appreciate any help or advise you could provide on this.
Regards,
2 Replies
- amitchandak
Super User
jjac_pbi_1979 , You can move series 3 up in the hierarchy /order and expand only till that level
Hello. Thank you so much for your response. The reason why the series are in that specific hierarchycal order is because that's the way information needs to be sort. First by series 3, then by 2, and then by 1, in the last place.
If I moved series 3 one level up, the information will be displayed in the wrong order, and the chart would stop making sense for the customer purposes.
What I need is to find a way to hide the series without excluding it from the chart nor the order hierarchy.
