cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MP_123 Member
Member

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

Capture.PNG

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

1 ACCEPTED SOLUTION

Accepted Solutions

Re: slicer that won't affect table

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

2 REPLIES 2

Re: slicer that won't affect table

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 Member
Member

Re: slicer that won't affect table

thank you! @BetterCallFrank