topic Re: Custom Visual Blank Value in Javascript/Typescript in Developer

Custom Visual Blank Value in Javascript/Typescript

Anonymous — Mon, 17 May 2021 18:27:34 GMT

Hi all,

My team is editing the pbiviz file for the "KPI Indicator" custom visual to force the visual to the "None" color it the case the data is BLANK. The issue is described below.

https://community.powerbi.com/t5/Desktop/KPI-Indicator-color-for-quot-None-quot-value-does-not-work/m-p/246484

Our solution was to just update the visual itself in the visual.ts file. The questions we are facing in doing this are the following:

1) How does Power BI pass on a BLANK() value in DAX to the visual? We believe it is the `kpiActual` variable but not sure.

2) How does one evaluate that variable, whatever it is, in javascript?

We've tried:

- if (....kpiActual == null) then {....do the coloring.....}

- if (....kpiActual == "undefined" then {....do the coloring...}

- Setting: diffText = "(" + GetKPIActualDiffFromGoal(kpiActual, kpiGoal, this.kpiCurrentSettings.kpi.bandingCompareType, this.kpiCurrentSettings.kpi.indicateDifferenceAsPercent) + ")"

- if (.... diffText != "(Blank)") then {.... do the coloring...}

None of these seem to work! Don't know much Javascript but it is absolutely essential for us to be able to set the color to gray in the case that the KPI Actual Value evaluates to BLANK()

Re: Custom Visual Blank Value in Javascript/Typescript

dm-p — Mon, 17 May 2021 22:48:00 GMT

Hi @Anonymous,

If you're attempting to modify a visual that is already published in AppSource, Power BI will always look it up and load it from there, based on its guid. I suggest you try switching on developer mode in Desktop to test the packaged visual, otherwise you'll never see the results of your changes if loading from a .pbiviz.

If this works, you'll then need to change the visual's guid in pbiviz.json to something else, so that it doesn't match the one in AppSource. This way, Power BI Desktop will treat your visual as a separate one and load it.

Bear in mind that because you're doing this, it will no longer treat the visual as certified because it no longer matches AppSource, so if you need these changes incorporating then I'd suggest contacting the developer of the visual to see if they can assist with this or accept your changes.

Regards,

Daniel

Re: Custom Visual Blank Value in Javascript/Typescript

Anonymous — Tue, 25 May 2021 18:33:52 GMT

@dm-p , your response was helpful. We were able to successfully modify the KPI Indicator visual by going to developer mode in the PBI Online Service. Changing the GUID was crucial for it to render. Thanks.