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 video, thanks, love the card’s visuals
thank you, Dean. It's really easy to understand and really easy to do.
Thank you so much! This was what I needed.
Thank you for the amazing video! It really helped me
HI Dean. can u share PBIX file of this kpi report. thanks
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.
VERY VERY GOOD VIDEO!!!! SUBSCRIBING!
It's amazing
Thank you, it's a gold :)
Great stuff
nice one
Great
Nice Video!
But.. Zooming in is very annoying..