Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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,
Solved! Go to 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
unichar
https://exceleratorbi.com.au/dax-unichar-function-power-bi/
https://unicode-table.com/en/blocks/miscellaneous-symbols-and-pictographs/
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.
@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
unichar
https://exceleratorbi.com.au/dax-unichar-function-power-bi/
https://unicode-table.com/en/blocks/miscellaneous-symbols-and-pictographs/
User | Count |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |