PowerBIIntegration: Zero Value in Dashboard shows as Blank in Power Apps

Like (0) Share

Report

Posted on 29 May 2020 01:35:00 by izzooot

I have a table visual to filter record into Power Apps:

Situation A: FieldA = some number -> work as expected

Situation B: FieldA = blank -> work as expected

Situation C: FieldA = 0 -> fail to work! ⚠️

Requirement: I need zero to show as zero, and blank to show as blank (display as-is), so workaround like this is not applicable.

I already spent almost a day to figure this silly thing out, hopefully the community will give helpful insights. It's unacceptable if this simple and natural "feature" does not exist in PA, hopefully I'm wrong. Sometimes, I hope system just don't be too "smart" to "help" blank-ify the zero value.

This is the formula in the gallery:

The text in the gallery:

Categories:

Connecting to Data

All responses (5)

Answers (1)

FrithjofVassbo 3 on 27 Aug 2022 at 10:17:13

Like (0)

Report

Re: PowerBIIntegration: Zero Value in Dashboard shows as Blank in Power Apps

I am also encountering the same problem
In my case, I am using measures from Power BI, in the PowerApps visual inside Power BI

When editing the app on make.powerapps.com (navigating from the Power BI report -> press Edit -> make.powerapps.com opens) the data from the PowerBIIntegration looks fine

But when viewing and interacting with the app in the Power BI report, the app won't recognize the zero values (or the blank values)

A sample gallery, as seen from the Power BI report:

The same gallery, as seen from inside the PowerApps editor (Power BI report -> Edit button -> make.powerapps.com):

The formula for the data in the gallery is: PowerBIIntegration.Data
The formula in the Value column is: ThisItem.MeasureName*1
The formula in the IsError column is: IsError(ThisItem.MeasureName)

I have already spent many hours on this
Is there any good workaround?

Fixing this should be prioritized
izzooot 8 on 30 May 2020 at 09:30:08

Like (0)

Report

Re: PowerBIIntegration: Zero Value in Dashboard shows as Blank in Power Apps

Thanks @v-xida-msft. Please do let me know if the team fixes the issue.
Verified answer

v-xida-msft on 29 May 2020 at 09:12:58

Like (0)

Report

Re: PowerBIIntegration: Zero Value in Dashboard shows as Blank in Power Apps

Hi @izzooot ,

Thanks for your feedback. If you would like to get further help in this issue, please consider submit an assisted support ticket through the following link:
https://powerapps.microsoft.com/en-us/support/pro

As an temporary solution, you could consider format the FieldA column as normal Text type in data set within your Power BI. Then add a new "PowerApps Custom Visual" based on the modified data set, then the issue would be fixed.

I would also post this issue to my Product Team, if the issue is fixed, I would also reply here.

Best regards,
izzooot 8 on 29 May 2020 at 09:03:29

Like (0)

Report

Re: PowerBIIntegration: Zero Value in Dashboard shows as Blank in Power Apps

@v-xida-msft, you are right, FieldA is a number field in Power BI. And also yes for FieldA = 0 shows blank in my embedded canvas app.

Thanks for your workaround. Unfortunately I can't use that since I have 50+ fields like FieldA. Creating copies of the fields will cause too much overhead, so I had to resolve to enforcing 0 value to both 0 and blank number fields. (Not to mention it feels so lacking that I need to create copies just to view 0 or blank).

I'll give some time for other people to take a stab, hopefully the MS official view this. But if still no other solution is proposed, I will accept your answer as solution.

Regardless, thanks for your attempt. Appreciate it.
v-xida-msft on 29 May 2020 at 07:57:04

Like (0)

Report
Re: PowerBIIntegration: Zero Value in Dashboard shows as Blank in Power Apps

Hi @izzooot ,

Could you please share a bit more about the "FieldA"? Is it a Number type column?

Do you mean that the FieldA = 0 shows blank in your embedded canvas app?

Based on issue that you mentioned, I have made a test, and the issue is confirmed on my side. If the FieldA field is a Number type column in your data set, the FieldA = 0 passed from Power BI report into the embedded canvas app would display Blank.

As an alternative solution, you could consider add a new column to your data set with same value as your FieldA, but format this new added column as a Text:

then re-add the "PowerApps Custom Visual" in your Power BI report, enable the new added column for this custom visual. Then within your embedded canvas app, you could use the following formula to reference the new added column value:

ThisItem.NewColumnName // ThisItem.FieldA_Copy

then you could display the 0 (zero) properly within your embedded canvas app.

Best regards,