Forum Discussion
conditional color change
Hello community,
from this data
| Product code | Product | Usage |
| TRN001 | Smart TV | Yes |
| TRN002 | Bicycle | No |
| TRN003 | Mobile | No |
| TRN004 | AC | No |
| TRN005 | washing machine | Yes |
| TRN006 | hand blender | Yes |
| TRN007 | hair clipper | No |
| TRN008 | screen | Yes |
| TRN009 | oven | No |
| TRN010 | digital receiver | No |
I need to have a shape that change it's color with the following condition
if the product is Mobile and used change the shape to green
if the product is smart TV and used change the shape to green
if any product is not used change the shape to red
you can find the excel and Pbix file in this link
or here https://we.tl/t-GBME9vvNQb
thank you in advance
12 Replies
Thank you Ibendlin
this is much appreciated, does this works with a shape like trinagle instead of table?
and can you share the pbix with mecan not thank you enough
Hi haniizz ,
Thanks for reaching out to the Microsoft fabric community forum.
We can't use shapes (traingle) instead of table, to represent the data.
If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thanks and Regards
this solution didn't work actually
here is what I get
"The value for 'Usage' cannot be determined. Either the column doesn't exist, or there is no current row for this column"see attached. You can change the conditional formatting to whatever you like.
