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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.