Different output of slicer

[Isgandar_B]

Hi Community,

I was 2 problems looking very similar, one of them i already solve, just in case of explanation i will explain it for first.

I have different measures in table, and have goal to make work pie chart (just for example) refering to my selection in top, 
Basicly like - If i select in top slicer Measure1, let me all pie chart calculations according this, if Measure 2 related to this, so it's works and i very like it.

I create table with selections and use this formula

Value selection = IF(

HASONEVALUE(MeasuresTable[Types]),

SWITCH(

VALUES(MeasuresTable[Types]),

"MSU", SUM(Data[MSU]),

"Gross", SUM(Data[Gross]),

"NET2", SUM(Data[NET2])

),

SUM(Data[MSU])

)

And lets get to my second issue

I have calendar table with month, date and so on. 
So according to some reasons i need get data some time for Calendar year, some time for Fiscal year.
How looks my table.
So what i want: i want make slicer selection on top of my page with 2 selections Fiscal year and Calendar year.
And if i select fiscal year it's must get to here FY_year columns, another case CY_year
I try to do this as described my first problem resolution via switch, but problem that i don't now how to refer to column, if i can do as described above formula it will be easiyer for me, but i can't use just column name insted of SUM calculation.

Kindly ask you help to me with this.

[Greg_Deckler · Accepted solution]

@Isgandar_B Maybe try creating a disconnected table for your slicer and then you can use SELECTEDVALUE along with SWITCH to return the right values in your measure.