Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

usuing color in slicers


my slicer represents my employees

i want each employee to have a unique color.

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



Community Champion
Community Champion


Use the Facet Key Custom Visual

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

That will do it!

Frequent Visitor

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

Community Champion
Community Champion

Okay I answered your original question! Smiley Happy


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)


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




Frequent Visitor


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


Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors