usuing color in slicers

[tamirka]

hi.

my slicer represents my employees

i want each employee to have a unique color.

i can't find a way to do so...

help!!

🙂

[Sean]

@tamirka

Use the Facet Key Custom Visual

https://app.powerbi.com/visuals/show/FacetKey1642434105453

Drag the Employee Name column to each of these fields - Facet, Instance and Count

That will do it!

[tamirka]

hi @Sean

it helps a little bit

the thing is i have 3 elements

the employees

amount of open tickets (bar)

ticket details (table)

lets say i have 10 tickets

if i use a slicer i can pick an employee, let's say John.

the amount of tickets will be filterd to 2 and if i press on the bar, i will see the details of those 2 tickets in the table.

in a facet (correct me if i am wrong), once i prees the bar it will automatically go back to 10 and will show me the division in the facet...

[Sean]

Okay I answered your original question!

Yes indeed with the Facet when you press the bar after its been filtered to 2 it will go back

(believe me I don't like this behavior and I've actually contacted the developer about this and other elements of it)

http://community.powerbi.com/t5/Desktop/Facet-Key-Custom-Visual/m-p/80087#M33380

What do you want to happen when the bar is hit when its filtered (or highlighted) to 2?

[tamirka]

Hi.

there is a table at the bottom.

i would like the table to show those 2 records...

i can't eem to attach a pic...

---