slicer that won't affect table

[MP_123]

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

[BetterCallFrank · Accepted solution]

Hi @MP_123,

please see my response in recent thread https://community.powerbi.com/t5/Desktop/Changing-column-graph-displayed-value/m-p/108427/highlight/...

There you can see the pattern you want to use.

HTH,

Frank

[MP_123]

thank you! @BetterCallFrank