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.
Hello,
I would like to create conditional formatting from a formula. I have already created a formula allowing this. When a field in the "Order status" (Statut de la commande) column is either "Request made"(Demande faite), or "Processing in progress" (Traitement en cours) or "Order made"(Commande faite) then a value applies.
The problem is that I would like to cross two tables in this same layout conditional form.
If the available stock <=Minimum stock and it has no order status then it has the number 8 for example. The problem is that this formula does not take despite a SUM to link the two tables.
As you can see below this screenshot, we have two cases (highlighted in yellow and circled in red) where our available stock is less than our minimum stock and where no process has been started and yet it does not appear in red.
Thank you for your help
Solved! Go to Solution.
Hi @Elie_HUCHET ,
Please try the measure.
MeF =
VAR color =
SWITCH (
SELECTEDVALUE ( 'Commande fournisseur'[Statut de la commande] ),
"Demande faite", 1,
"Traitment en cours", 2,
"Commande faite", 3,
"Recue", 4
)
RETURN
IF (
color <> BLANK (),
color,
IF (
SUM ( 'Extraction detaillee'[Stock Disponible] )
< SUM ( 'Extraction detaillee'[Mini] ),
8,
0
)
)
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
THANK YOU IT'S OK!! 🙂
Hi @Elie_HUCHET ,
Please try the measure.
MeF =
VAR color =
SWITCH (
SELECTEDVALUE ( 'Commande fournisseur'[Statut de la commande] ),
"Demande faite", 1,
"Traitment en cours", 2,
"Commande faite", 3,
"Recue", 4
)
RETURN
IF (
color <> BLANK (),
color,
IF (
SUM ( 'Extraction detaillee'[Stock Disponible] )
< SUM ( 'Extraction detaillee'[Mini] ),
8,
0
)
)
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.