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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Rasitha_PB
Frequent Visitor

conditional background formatting to table based on slicer selection

Hi Folks,

Here is the problem..


I want to get below result as of below screenshot using below data model and slicer and table

Rasitha_PB_0-1622031026572.png

Rasitha_PB_1-1622031082226.pngRasitha_PB_2-1622031109940.png


Please note that , Slicer and table is used with same store field from store table.

So I want to get background colour enabled in the table rows based on the slicer value selected in the slicer.

 

I want an idea measure to be used without creating extra tables.

 

Thank you

4 REPLIES 4
v-rzhou-msft
Community Support
Community Support

Hi @Rasitha_PB 

If you build a relationship between Sales and Store table, you couldn't use conditional background formatting successuflly. Due to the relationship and slicer and table is used with same store field from store table, Power BI will make all selected judgment results return true. 

1.png

It is better for you to build an extra unrelated store table. Or you can remove the relationship between Stores and Sales table, then use Sales[Store] in table instead of Store[Store] and build a new measure to calculate the Sum Amount per Stores. Then you can use conditional formatting in table visual successfully.

 

Best Regards,

Rico Zhou

 

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

@Rasitha_PB , to do this you need slicer using an independent slicer table.

 

Then you can have measure like

color =

Switch( True () ,

max(Table[store]) in values(Store[Store]) , "Blue",

"White"

)

 

Then you can use conditional formatting with the field value option and use this measure

 

if needed , check

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

Hi @amitchandak ,

I am trying to find a different way , as I have many visuals in a Dashboard page as some of them are connected to this slicer.

Anonymous
Not applicable

Hi @Rasitha_PB 

 

Please refer to this video,

 

https://www.youtube.com/watch?v=DLq5i1mlFqg&t=277s

 

Thanks

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors