Relation

[Acalmeida21]

Good Afternoon,

I'm trying to build a vision with some informations, which I use two spreadsheets (in excel).

I want to show a green circle when my relation does not find a result. You can see on the picture below:

I'm showing all information of column "Nome", one of the two spreadsheats, but, when I realize the relation with the spreadsheat of the column "Farol" i have to show a green picture for those lines that does not have a result.

Thanks,

[Anonymous]

Hi @Acalmeida21 ,

Please provide some data on the two spreadsheets (in excel) and expected output.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Acalmeida21 , Try to create a unichar measure and use that in visual wih green font color or do the condition formatting with green color

if(Isblank(Max(Table[Name]) , UNICHAR(11044), blank())

refer this too

https://community.powerbi.com/t5/Desktop/Set-UNICHAR-11044-color-to-green-and-red-with-out-any-condt...

unichar 

https://exceleratorbi.com.au/dax-unichar-function-power-bi/

https://unicode-table.com/en/blocks/miscellaneous-symbols-and-pictographs/