Select Specific column to Highlights

[Anonymous]

Hi everyone,

IM NEW AT POWER BI DESKTOP 

IM CURRENTLY FACING PROBLEM ON HOW TO HIGHLIGHT SPECIFIC COLOMN

This is my task i want to do

image 1. shown if I click  9 (highlights on buying_uom)

image 2.  When i click 10 (Buying_uom) still in hightlight , I Want to hightligts only Selling_uom. 

image 3 . , also in this image too, I want to highlight only Cost

Is it posible on your end to Do this Task ? 

Please Help.

[Anonymous]

@amitchandak 

i try conditional formating on Buying_uom and apply measure 2 . 

but color didnt apply.

[Anonymous]

@amitchandak  THANK YOU FOR YOU QUICK RESPONSE 

I ALREADY CREATE 

3 MEASURE

HOW CAN I APPLY THIS MEASURE

[amitchandak]

@Anonymous , Check the step followed in this video, (Start from t=531, already there in URL)

https://youtu.be/M5PvQUy-L_4?t=531

[amitchandak · Accepted solution]

@Anonymous , You have to create 3 color measures like these

If(selectedvalue(Table[Rule_id]) =9, "grey", "white") 

If(selectedvalue(Table[Rule_id]) =10, "grey", "white")

If(selectedvalue(Table[Rule_id]) =7, "grey", "white")

And use them in conditional formatting to respective column, background color -> Advance option -> "Field value" and then use one of the required measures

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values