Forum Discussion
up arrow / show a shape based on a formula
Community ChampionThere 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.
So how could we show the difference between two figures?
- Greg_Deckler
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.
Yes of course.
I am trying to migrate an existing excel dashboard to power BI.
In this dashboard we show the current score and compare then to the previous score. We do not show the previous score but use a formula to compare them.
The formula we use results in either a p or a q. I then use wingdings 3 to convert the p’s and q’s into up and down arrows and then use conditional formatting to make the font red or green.
The other solution we have is to use VBA showing an up arrow and hiding the down or vice a versa based on a formula.
I know arrows our a little old hat but my clients like them
Thanks in advance.
