Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
mbregunci
Frequent Visitor

Power BI mobile APP -   showing instead of blanks

Hi Community,

 

I'm having the following error on pbi mobile app "show as table" option:

nbps error.png

The HTML code: " " for blank/space is being displayed when the value is supposed to be "BLANK".

 

On PBI desktop and service the values are showing as expected (not showing anything) but when the user opens the report using PBI mobile app and click on "show as table" instead of showing "blank" the table is showing   html code.

 

To be clear: I'm not using any HTML as any source of data.

Below you can see the formula I'm using.

 

 

current year = 
VAR cumulative = 
    CALCULATE(
        [measure]
        ,KEEPFILTERS( YEAR(fact_table[date]) = YEAR(TODAY()))
    )

RETURN
IF(
      VALUES(Date_Dim[Day]) > [Max Current day]
    , BLANK() 
    , cumulative
)

previsous year = 
VAR cumulative = 
    CALCULATE(
        [measure]
        ,KEEPFILTERS( YEAR(fact_table[date]) = YEAR(TODAY())-1)
    )
RETURN
cumulative

 

 

 

1 ACCEPTED SOLUTION

Hi @rubayatyasmin ,

We are working on releasing a fix. We expect it to be available by early August.

This is a service side fix, therefore there is no need to upgrade the app in order to enjoy it.  

Thanks,

Michal

View solution in original post

5 REPLIES 5
mbregunci
Frequent Visitor

This problem is now solved!! Thank you @michalfoster 

rubayatyasmin
Super User
Super User

Hi, @mbregunci 

 

  1. Update Your Power BI Mobile Application: Sometimes, the issues are related to the version of the application you're using. Ensuring you have the latest version of Power BI Mobile can potentially resolve this issue.

  2. Workaround: Instead of leaving the value as blank, you might replace the blank value with an empty string ("") or a placeholder like "N/A". This will prevent Power BI Mobile from displaying  .

 

if none of this works then you might want to report a bug. 

 

rubayatyasmin_0-1689517080227.png


Did I answer your question? Mark my post as a solution!super-user-logo

Proud to be a Super User!


Hi @rubayatyasmin ,

We are working on releasing a fix. We expect it to be available by early August.

This is a service side fix, therefore there is no need to upgrade the app in order to enjoy it.  

Thanks,

Michal

Hi, @michalfoster @Good to know that.

 

Thanks. 


Did I answer your question? Mark my post as a solution!super-user-logo

Proud to be a Super User!


Hey @rubayatyasmin ,

I've tested it in several phones and the problem was always there.

And since I did not have any reply here, I decided to open an ISSUE for it. The Microsoft team said that this is really a bug and they are looking into it. 

BUG: HTML code "&nbsp" is displaying instead of bl... - Microsoft Fabric Community
I will post it here as soon as it will be fixed.

 

Thank you

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.