SWAP LEGENDS IN DONUT CHART

Hi Pragati11 ,

The method i tried is pasted below.

FCST_SELECTION_METRICS = 
IF (
HASONEVALUE ( FCST_NAME_TABLE[FCST_NAME] ),
SWITCH (
SELECTEDVALUE ( FCST_NAME_TABLE[FCST_NAME] ),
"ARIMA", SUMX('ACCRY_TEST_05_OCT',[ARIMA_FCST] ),
"ETS", SUMX('ACCRY_TEST_05_OCT',[ETS_FCST_ADJ]),
"LREG", SUMX('ACCRY_TEST_05_OCT',[LREG_FCST] ),
"MAVG", SUMX('ACCRY_TEST_05_OCT',[MAVG_FCST] )
)
)

this method i have written to change the FCST columns in line chart.

here my FCST_NAME_TABLE has 4 rows in FCST_NAME column which have values (ARIMA,ETS,LREG,MAVG).

once we click on ARIMA in the slicer the line chart will be changing and will show the trend of ARIMA FCST. and we are summing that up using sumx.

Now in the scenarios which i have mentioned i have country,size,type inplace of ARIMA_FCST,ETS_FCST and so on.....

FCST_SELECTION_METRICS = 
IF (
HASONEVALUE ( TEST[COLUMN] ),
SWITCH (
SELECTEDVALUE ( TEST[COLUMN] ),
"COUNTRY", ACCRY_TEST_05_OCT[COUNTRY] ,
"SIZE", ACCRY_TEST_05_OCT[SIZE]
)
)

The code i am using is like this, where i m trying to switch text columns in pie chart not the measures.

Which BI is not allowing.

The provided soultion can work fine but that demands the data to be duplicated.

Hope i have explained well.

Thanks

Hi amitchandak ,

Basically i just want to have a pie chart, In which i can change legends but not the measure.

E.g.

based on the data i have pasted.

If i have a slicer which has values as (COUNTRY, SIZE, TYPE),

and i click on country i should have a pie chart which will show the unique count of items for all the country.

India - 4 items
US - 2 items
UK - 3 items 

but once i select type in the slicer

the above pie chart will be changed as follows.

regular- 4 items

fancy - 5 items.

Hope it is clear now.

Thanks