Create a pie chart with a calculated column that varies with filters
Hi everyone, I am having problems creating a pie chart that has to change with filters, so far i already create a chart but only works when i don't apply the filters, the moment i apply one filter the chart does not shows the right filtered data, and that's because the chart uses a calculated column named "CHART" that i created with a condition : CHART = IF([WEIGHT]>20,"Order greater than 20","Order less than 20") but when the weight variates deppending on the filters my column with the condition doesn't take on count the new weight filtered. It stays with the total weight. when i use the same code but in a measure instead of in a new column, it actually changes deppending of the new filtered weight, the problem is that i can't use a measure as "Legend" for my pie chart. here's a example of my data base that i recreate in excel (the original actually has more "FILTERS" and data in general): here's without filters: and i achieved a chart like this one: it count and divides in a chart how many "ORDER" are "GREATER THAN 20 pounds" and how many not, using "CHART" as Legend and "Count of ORDER" as Value. I would like to create a calculated column "CHART" that recalculates the values of the weight deppending on the filters (as a measure does), i.e: (look that the weight changes deppending on the filters and also the "CHART" column should do it) So i can use this column for my pie chart, or if this is not possible, how can i do more charts like the first one but with the new values of the weight after the filters. I hope i have explained myself enough, english it is not my first language Thank you all for your help and time. 🙂
