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.
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.
Solved! Go to 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
@amitchandak 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)
https://youtu.be/M5PvQUy-L_4?t=531
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |