Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi Folks,
Here is the problem..
I want to get below result as of below screenshot using below data model and slicer and table
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
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.
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.
@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.
Hi @Rasitha_PB
Please refer to this video,
https://www.youtube.com/watch?v=DLq5i1mlFqg&t=277s
Thanks
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
93 | |
89 | |
83 | |
75 | |
49 |
User | Count |
---|---|
142 | |
140 | |
110 | |
69 | |
55 |