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.
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/
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.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |