Dynamic Sorting stacked bar chart based on slicer value
I have one slicer and 3 Stacked bar charts and this bar chart contains only X-axis and legends. In my slicer, I have values like 1,2,3,4 when I select 1 or 2, or 3 my stacked bar chart should sort according to alphabetic order but instead of these three when I select 4 My stacked bar chart has to be sorted based on legend value, not the alphabet. Thank you in advance for whatever effort you are giving into this problem.
Hide values in bar chart where value is 0
I am using a clustered bar chart to display the Sick Days taken by different teams. Here is a sample of my table: Sales Team Development Team Operations Team Product Dev Team Sick days taken 0 3 2 0 My chart is currently showing all 4 teams, even those with the value of 0. How do I get it to only showing teams with more than 1, and not show the Sales & Product Dev Team on the chart? I've tried look through a few forums and can't find a solution, I also can't do an advanced filter for some reason on e.g. "Sales Team" to only show values more than 0. Thanks for your help.
