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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply

apply conditional formatting to a slicer power bi

Hello all! 

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

Snag_16603db.png

 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 

Snag_167aa76.png

 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 

yazenbarakat123_0-1659469409884.png



Any help would be appreciated thank you!! 

 

1 ACCEPTED SOLUTION
v-jianboli-msft
Community Support
Community Support

Hi @yazenbarakat123 ,

 

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

vjianbolimsft_4-1661417063806.png

 

Please try:

vjianbolimsft_1-1661416903174.png

Output:

vjianbolimsft_2-1661416929959.png

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

First create a new table for slicer

vjianbolimsft_3-1661417031788.png

Then add a new column:

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

Manage relationships:

vjianbolimsft_5-1661417182344.png

Final output:

vjianbolimsft_6-1661417214377.png

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.

View solution in original post

3 REPLIES 3
v-jianboli-msft
Community Support
Community Support

Hi @yazenbarakat123 ,

 

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

vjianbolimsft_4-1661417063806.png

 

Please try:

vjianbolimsft_1-1661416903174.png

Output:

vjianbolimsft_2-1661416929959.png

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

First create a new table for slicer

vjianbolimsft_3-1661417031788.png

Then add a new column:

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

Manage relationships:

vjianbolimsft_5-1661417182344.png

Final output:

vjianbolimsft_6-1661417214377.png

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
Super User
Super User

@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

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

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors