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 all,
Hope someone can help me with the following.
I have a table in my report:
quantity | order_nr | customer | container_nr | line |
1 | 8822598 | ONE | BMOU9715033 | Adjusted configuration |
1 | 8822598 | ONE | BMOU9715033 | Humidity sensor |
1 | 8822598 | ONE | BMOU9715033 | Photo fee (for Kramer only) |
1 | 8822598 | ONE | BMOU9715033 | Photo fee (RWG/Antwerpen) |
1 | 8822504 | ONE | BMOU9718855 | Cable splice 1x |
1 | 8822504 | ONE | BMOU9718855 | Fresh air vent cleaning |
1 | 8822504 | ONE | BMOU9718855 | Photo fee (RWG/Antwerpen) |
1 | 8822504 | ONE | BMOU9718855 | System to block / leaktest / vacume |
1 | 8822504 | ONE | BMOU9718855 | TXV cover refit |
1 | 8822504 | ONE | BMOU9718855 | Universal Drier |
1 | 8821228 | ONE | BMOU9722222 | Fresh air vent cleaning |
1 | 8821228 | ONE | BMOU9722222 | Operation name plate |
1 | 8821228 | ONE | BMOU9722222 | Photo fee (RWG/Antwerpen) |
1 | 8821245 | ONE | BMOU9728010 | HMC setting adjust |
1 | 8821245 | ONE | BMOU9728010 | Humidity sensor |
1 | 8821245 | ONE | BMOU9728010 | Photo fee (RWG/Antwerpen) |
1 | 8822453 | ONE | BMOU9756182 | Photo fee (RWG/Antwerpen) |
1 | 8822453 | ONE | BMOU9756182 | System to block / leaktest / vacume |
1 | 8822453 | ONE | BMOU9756182 | Universal Drier |
1 | 8821574 | ONE | BMOU9869954 | Photo fee (RWG/Antwerpen) |
1 | 8821574 | ONE | BMOU9869954 | Suction sensor |
1 | 8822493 | ONE | CXRU1145529 | Adjusted configuration |
1 | 8822493 | ONE | CXRU1145529 | Photo fee (RWG/Antwerpen) |
I want to automatically change the colour of the lines, beloning to an order_nr.
Someting like this:
Is there a way to do so in Power BI?
Thanks for your help!
John
Solved! Go to Solution.
HI @jwi1
Yes but you'd need to set the conditional formatting for the background color of each field. That is, set it separately for quantity, order_nr, customer, container_nr and line.
Alternatively, you could just set it for one of those fields to draw attention to it, like so
Check the sample file I linked to above.
Regards
Phil
Proud to be a Super User!
HI @jwi1
Yes but you'd need to set the conditional formatting for the background color of each field. That is, set it separately for quantity, order_nr, customer, container_nr and line.
Alternatively, you could just set it for one of those fields to draw attention to it, like so
Check the sample file I linked to above.
Regards
Phil
Proud to be a Super User!
Thanks! This will do the job.
Regards,
John
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 |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |