KPI visual shows BLANK() when there is a GOAL but not callout value.
I tried creating a measure to modify the green colour and show it white (#ffffff) to hide the Blank() within the background with this:
Go to Solution.
Thanks for your answers, but... placing a 0 does not work, because 0 means 0 and it's different than blank. Also, the second option is not valid for KPI visual, which needs a numeric number.
The solution I found was using LEN(). if (LEN(measure) >0, #colour, #transparent)
View solution in original post
Please consider these 2 options and click thumbs up and accept as solution buttons. Thanks 😎
I have added comments to expalin how they work
// By adding zero you can force dax to always return 0 instead of blank
LASTNONBLANKVALUE('RAM Indicator ratings'[Target value],0)
// Use the if command to return "" insteas of blanks
VAR answer = LASTNONBLANKVALUE('RAM Indicator ratings'[Target value],0)
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.