Forum Discussion
Select Specific column to Highlights
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 , 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
4 Replies
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-valuesamitchandak THANK YOU FOR YOU QUICK RESPONSE
I ALREADY CREATE
3 MEASURE
HOW CAN I APPLY THIS MEASURE
Anonymous , Check the step followed in this video, (Start from t=531, already there in URL)