Skip to main content
cancel
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.

Reply
tamirka
Frequent Visitor

usuing color in slicers

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

🙂

4 REPLIES 4
Sean
Community Champion
Community Champion

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

Sean
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)

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?

 

Facet.png

 

tamirka
Frequent Visitor

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

 


Helpful resources

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