Forum Discussion
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
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/true#M45588
There you can see the pattern you want to use.
HTH,
Frank
2 Replies
- BetterCallFrank
Resolver IV
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/true#M45588
There you can see the pattern you want to use.
HTH,
Frank
- MP_123
Microsoft Employee
thank you! BetterCallFrank