apply conditional formatting to a slicer power bi

[yazenbarakat123]

Hello all! 

I have created a conditonal format column too add to my table depending on my total of (Float days) as seen below 

 using this measure  

Status Color =

IF ([FloatPerActivity]< 0 , "CircleLow",

IF( [FloatPerActivity] >= 0 && [FloatPerActivity]<=10 , "CircleMedium",

if( [FloatPerActivity]> 10 , "CircleHigh",

IF([FloatPerActivity] = 0 , "CircleMedium"))))

however in my tablei was easily able to change the hard code to Icons but the issue im running into is managment wants to be able to slice using this conditional column but the options in the slicer show up as the hard code ... like this 

 is  there a way for me to keep the conditional formatting in the table but rename the options in the slicer for managment to undertand or perhaps use the same icons the slicer works i just dont expect upper managment to correalte the icon with the hard code 

Any help would be appreciated thank you!! 

[v-jianboli-msft · Accepted solution]

Hi @yazenbarakat123 ,

Based on your description, I have created a simple sample:

Please try:

Output:

If you want to change the value of slicer, please try:

First create a new table for slicer

Then add a new column:

Column = SWITCH([Custom],
"CircleLow","A",
"CircleMedium","B",
"C")

Manage relationships:

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@yazenbarakat123 , if this dynamic segmentation using measure, then in the table you can have display value, join or filter value

Like in this case I have table with generate series , where I join with values, but I can additional column for filter

Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ

[yazenbarakat123]

Hello thanks for the response but I'm not sure how this relates to my question above