Category Slicer

[Anonymous]

HI Everyone, 

Urgent help needed.

i have 4 categories- covid 19,escalation,online payment,truck roll. I have used them as sum of cat in bar, % out of total in line with month.

All this cat are in diff column, what i need is a slicer which can filter out each cat with its %

ex- if i click covid 19- it should give me covid nos and % of covid. 

i tried using them in Switch() after making a separate table, however the problem is it only gives me an option of single selection, and if i select multiple it gets blank. Also, when i dont select anything on slicer, it gets blank again, however i want it should give me the below visuals.

My measures:1.

Cat Slicer = SWITCH(TRUE(),VALUES('Category'[Cat Name])= "Covid 19",[Covid 19],VALUES('Category'[Cat Name])= "Online Payment",[Online Payment],VALUES('Category'[Cat Name])= "I tried",[I tried],VALUES('Category'[Cat Name])= "Customer Escalations",[Customer Escalations],VALUES('Category'[Cat Name])= "Truck Roll",[Truck Roll],BLANK())

 2.

%Slicer = SWITCH(TRUE(), VALUES('Category'[Cat Name])= "Customer Escalations",[%Customer Escalations],VALUES('Category'[Cat Name])= "Covid 19",[%Covid 19],VALUES('Category'[Cat Name])= "I tried",[%i tried],VALUES('Category'[Cat Name])= "Online Payment",[%Online Payment],VALUES('Category'[Cat Name])= "Truck Roll",[%Truck ROll],BLANK())

Please help!!

[V-pazhen-msft · Accepted solution]

@Anonymous 

I don't think you should use values() that return a single column table, try replace Values() to SUM,MAX, or MIN. 

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
 

[parry2k]

@Anonymous I would recommend to share sample data and expected output. Read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490