cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
izzooot
Frequent Visitor

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

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

 

Situation A: FieldA = some number -> work as expectedsituationA.png

 

Situation B: FieldA = blank -> work as expected

situationB.png

 

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

situationC.png

 

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:

formula1.png

 

The text in the gallery:

formula2.png

1 ACCEPTED SOLUTION

Accepted Solutions

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-xida-msft
Community Support
Community Support

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:

1.JPG

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:

2.JPG

ThisItem.NewColumnName    // ThisItem.FieldA_Copy

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

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@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.

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (2,646)