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, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare 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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors