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.
What error do you get in place of the visual? It's a Power BI core visual so it should work. Might be an issue with your admin settings. I use it a lot and never had issues with it not showing.
@DeanChereden not sure why my previous reply is gone but basically if I only use reference labels I don't have problems but if I had detail to a reference label the visual won't show in BI service. I've seen other people complaining about the same issue and it was supposed to be fixed last year
I've been trying to recreate the issue but it seems to be working fine in the report I published. I wonder if it's a regional thing. Does it work in this report? app.powerbi.com/view?r=eyJrIjoiMmVmNTc1NTQtY2I4Ni00OGNkLWI0OGEtNzRkNDc0MjU0OTdjIiwidCI6IjY5NjYzY2E5LTcyYTktNDgyYy05NmNhLTUyYWUxMThhODQ1MCJ9
Helpful and practically doable! New sub here.
Great video, thanks, love the card’s visuals
Thank you so much! This was what I needed.
thank you, Dean. It's really easy to understand and really easy to do.
Thank you for the amazing video! It really helped me
Thank you, it's a gold :)
It's amazing
The link to the source file is broken
Amazing
Great stuff
VERY VERY GOOD VIDEO!!!! SUBSCRIBING!
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.
nice one
HI Dean. can u share PBIX file of this kpi report. thanks
I am not getting the dataset from the supplied link. It is showing Oops! We can't find that page. Please help with new link
You need to be logged into data.world to view the datasets
Great
The problem with this card is that it won't show after publishing
What error do you get in place of the visual? It's a Power BI core visual so it should work. Might be an issue with your admin settings. I use it a lot and never had issues with it not showing.
@DeanChereden not sure why my previous reply is gone but basically if I only use reference labels I don't have problems but if I had detail to a reference label the visual won't show in BI service. I've seen other people complaining about the same issue and it was supposed to be fixed last year
I've been trying to recreate the issue but it seems to be working fine in the report I published. I wonder if it's a regional thing. Does it work in this report? app.powerbi.com/view?r=eyJrIjoiMmVmNTc1NTQtY2I4Ni00OGNkLWI0OGEtNzRkNDc0MjU0OTdjIiwidCI6IjY5NjYzY2E5LTcyYTktNDgyYy05NmNhLTUyYWUxMThhODQ1MCJ9
Nice Video!
But.. Zooming in is very annoying..