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

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
Fabcon_Europe_Social_Bogo

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.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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