Forum Discussion

MP_123's avatar
MP_123
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago
Solved

slicer that won't affect table

hi, i want to show KPI regarding a slicer selection.

for example - if user chose WAU, so show WAU and others.

the problem is - i don't have  a column with this three values. i tried to create new column with each of the values randomaly.

this way is not the best since the slicer do filter my table and that's what i don't want since the calculated measures are not correct

the measure i want to show is (if(values)='WAU', calculate . . . , if(values)="No of Active Days", calculate . .  etc.

what are my option?

i want a slicer which won't affect the table, but only for the User's UI

 

thanks! hope this is clear