Forum Discussion
Conditional formatting 2 columns to return colour
Super Userbansikpopat , you have to create color measure based on these measures you have for Delivery
example
Color =
var _del = divide(sum(Table[Delivery quantity]), sum(Table[New_Stock] ) )
return
if(_del <.9, "Yellow", "white")
You can use the same in conditional formatting using the field value option
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3
It does not woek when I try to create a new measure.
My requirement is to compare the delivery quantity and stock quantity. Both of these values are from different tables which are connected using many to many relation.
Example :
1. I am creating a measure in "Delivery" table to reference 90% stock colum from "Stock" table, but it does not suggest me any column from delivery table.
The idea is to basically get the 90% stock and delivery quantity columns in one table to do easier conditional formatting. However, creating new measure to refer columns is not working.
