Forum Discussion
Showing an asterisk on a data visual
Hi Power BI experts,
Is there a way to show an asterisk on a data viz, e.g. bat chart or pie graph?
In the PBIX files linked, I can mask the data, which is fake, via an asterisk in a table or matrix.
However, the asterisk does not appear when I build a viz with the same data. Is there a way for the viz to show the asterisk?
Thank you,
Luis
3 Replies
- parry2k
Super User
Anonymous you can take advantage of new dynamic formatting and do something like this for the format :
IF ( SELECTEDMEASURE () <= 5, "*" )Check this video on my YT channel about this new feature: From Thousands to Billions: The Power of Dynamic Formatting in Power BI - April 2023 Power BI Update - YouTube
Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
Hi parry2k - thank you for your nudge. Your video was super helpful.
I suspect the reason I don't have dynamic formatting is that I have a report measure instead of a model measure.
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-dynamic-format-strings
- parry2k
Anonymous you need to create a measure and then in the format select dynamic that's where you will this condition.
Anonymous
