Forum Discussion
Filtering a value in pie chart without changing other value's percentages
- 8 years ago
Hey jlankford I have just checked, and --at least in the free version of-- Donut Chart by ZoomCharts there is no option to select how the Data Labels are displayed.
In a normal donut / pie chart though, there is.
I have tested this measure:CostPerc = VAR y = SUM ( [Value] ) + 0 VAR x = CALCULATE ( SUM ( [Value] ), ALL ( Table ) ) RETURN DIVIDE ( y, x, 0 )In modeling, you can choose to display it as a percentage. This measure always calculates the complete total value, thus even if you filter out one or more IDs the other IDs' percentage won't change.
- 8 years ago
Thank you very much! I just realized that I was making this WAY harder than it had to be. By calculating share of total, and then using that value independently of the "percentage" calculated by the pie, I simply display values.
Hey jlankford I have just checked, and --at least in the free version of-- Donut Chart by ZoomCharts there is no option to select how the Data Labels are displayed.
In a normal donut / pie chart though, there is.
I have tested this measure:
CostPerc =
VAR y =
SUM ( [Value] ) + 0
VAR x =
CALCULATE ( SUM ( [Value] ), ALL ( Table ) )
RETURN
DIVIDE ( y, x, 0 )In modeling, you can choose to display it as a percentage. This measure always calculates the complete total value, thus even if you filter out one or more IDs the other IDs' percentage won't change.
Thank you very much! I just realized that I was making this WAY harder than it had to be. By calculating share of total, and then using that value independently of the "percentage" calculated by the pie, I simply display values.