This is nice. I wonder if instead of using UNICHAR to return the up and down arrows you could write it into the VAR targetpercent using custom formatting like you can for a measure in format on the ribbon in measure tools. I know this works to return up and down arrows based on positive and negative values although you can't currently write colours into the formatting like you can in excel. So it would change from - VAR targetpercent = FORMAT(DIVIDE(targetdiffamount, target,0),"0.0%") to VAR targetpercent = FORMAT(DIVIDE(targetdiffamount, target,0),"▲ "0.0%;"▼ "0.0%; I might test it and see. It just means that you do not have to create 2 additional variables and call them in the returned result. You could just return the targetpercent.
Amazing
thank you, Dean. It's really easy to understand and really easy to do.
Great video, thanks, love the card’s visuals
HI Dean. can u share PBIX file of this kpi report. thanks
Thank you so much! This was what I needed.
It's amazing
Thank you for the amazing video! It really helped me
Great stuff
Thank you, it's a gold :)
This is nice. I wonder if instead of using UNICHAR to return the up and down arrows you could write it into the VAR targetpercent using custom formatting like you can for a measure in format on the ribbon in measure tools. I know this works to return up and down arrows based on positive and negative values although you can't currently write colours into the formatting like you can in excel.
So it would change from -
VAR targetpercent = FORMAT(DIVIDE(targetdiffamount, target,0),"0.0%")
to
VAR targetpercent = FORMAT(DIVIDE(targetdiffamount, target,0),"▲ "0.0%;"▼ "0.0%;
I might test it and see. It just means that you do not have to create 2 additional variables and call them in the returned result. You could just return the targetpercent.
Great
VERY VERY GOOD VIDEO!!!! SUBSCRIBING!
nice one
Nice Video!
But.. Zooming in is very annoying..