Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I would like to display a green arrow when my balance percentage is >-80% and a red arrow if my balance percentage is <80%. I've successfully created a new table with my Image URLs, however, my balance percentage is a calculated measure in another one of my tables and I can't create a connection to the Image table (that balance measure donesn't show up in the query columns in order to make the connection). I also need to filter by Date and Location and as the balance percentges change, I would need the images to change.
Thanks in advance for your assistance!
Hi @Anonymous ,
One sample for your reference. We can use UNICHAR to work on it. Please check the following steps as below.
1. To create two measures as below.
Measure = VAR Down = UNICHAR ( 11167 ) VAR Up = UNICHAR ( 11165 ) var a = SUM('Table'[per]) RETURN IF ( a <0.8, Down, Up)
Measure 2 = SUM('Table'[per])
2. To format the visual by the measures.
Ok, this worked, but I'm not getting arrow shapes, I'm getting small rectangular/squarish shapes. Do I need to change a setting or font?
Thanks!
I'm not sure. You may need to. Could you send me a screenshot of what you had before vs now?
There's also the option of adding small images to your report (a green up arrow and red down arrow for example) and have PBI display the icon's image instead of using text to create an icon.
Hi this is great, but my percentages are actually a quick measure and your formula accomodates a table field and won't accept the quick measure when I try to use it. Also, what does "var a" represent? is the "a" a category in my table?
Thanks!
var a should be set to equal your measure.
User | Count |
---|---|
88 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
96 | |
92 | |
91 | |
75 | |
69 |