Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
101 | |
90 | |
79 | |
70 | |
69 |
User | Count |
---|---|
112 | |
96 | |
96 | |
75 | |
72 |