conditional color change

[haniizz]

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

[haniizz]

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"

[lbendlin]

see attached.  You can change the conditional formatting to whatever you like.

[lbendlin]

[haniizz]

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 me

can not thank you enough

[v-dineshya]

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

[v-dineshya]

Hi @haniizz ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and consider giving a KUDOS. Feel free to reach out if you need further assistance.

Regards,
Dinesh

[haniizz]

Hi Denish,

the given solutions didn't solve the issue.

I changed the dashboard idea

[v-dineshya]

Hi @haniizz ,

Thank you for reaching out to the Microsoft Fabric Community forum.

I’d recommend submitting this as a feature request in the official Power BI Ideas forum:
https://ideas.fabric.microsoft.com/

The Product team actively reviews suggestions there, and if others in the community upvote it, it could be considered for future updates.

I trust this information proves useful. If it does, kindly “Accept as solution” and give it a 'Kudos' to help others locate it easily.
Thank you.

[v-dineshya]

Hi @haniizz ,

Could you please confirm if you've submitted this as an idea in the Ideas Forum? If so, sharing the link here would be helpful for other community members who may have similar feedback.

As we haven’t heard back from you in a long while, we’re closing this thread. For any further discussions or questions, please start a new thread in the Microsoft Fabric Community Forum — we’ll be happy to assist.

Thank you for being part of the Microsoft Fabric Community.

[haniizz]

Hello Dear,

all solution didn't work with my case

I figured another solution

thank you

[v-dineshya]

Hi @haniizz ,

We are pleased to hear that you have found a workaround. Please share the details here and mark it as 'Accept as solution' to assist others with similar issues. 
Thank you.

[v-dineshya]

Hi @haniizz ,

We are pleased to hear that you have found a workaround. Please share the details here and mark it as 'Accept as solution' to assist others with similar issues. 
Thank you.