Forum Discussion
up arrow / show a shape based on a formula
Hi all.
I just want to show a shap (in this case a green arrow) based on a comparision between two numbers.
24 Replies
- ruthpozuelo
Post Prodigy
Hi,
You can also use Cambria Math symbols to display the arrows.
Using a similar example smoupre gave you, the formula would look like:
Key = IF([Rank Trend]>-1,"⇧", "⇩")
You can copy the arrows directly from this thread into power bi.
/Ruth
- belenquirogaRegular Visitor
Thanks, I think this is the right solution
- PHunosøeFrequent Visitor
Hi
I have a problem finding the solution to this question.
Can anybody help ?
Kr / Per Hunosøe
- AnonymousNot applicable
Hi all,
Thanks for your contribution to the Community , I am learning and enjoying it because of you guys.
I have tried the KPI indicators using ruthpozuelo method as well as smoupre, I was able to use Unicode symbols in both Table and Matrix , Since I needed coloured arrows I was working with Image url's also, But it was not working as expected for me in Matrix.Any workaround for this? I have shared a sample published link for your understanding.
Regards
- pekkakRegular Visitor
ravsha85, can you share us your desktop file?
- Greg_Deckler
Community Champion
There currently is no ability to edit interactions with shape visualizations or, to my knowledge, any kind of "conditionality" that you can have on shape visuals.
You could potentially get there with a custom column and a related table. What I am thinking of would be a table with your shapes loaded as images (URLs) along with something like an associated number or something, 1, 2, 3. You could have a custom column that based upon the comparison of two numbers, resulted in 1, 2, 3. IF([comparison]>xx,1,2) something like that. Then place the image in a table or card and filter it based upon the item selected. Obviously, I don't know anything about your data and this potential solution would only work in specific circumstances.
- AuraCorpNew Member
So how could we show the difference between two figures?
- Greg_Deckler
Community Champion
AuraCorp - Can you provide a little more information on what you are trying to accomplish? I'm not following what you are trying to do.