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
Hi Community,
I'm having the following error on pbi mobile app "show as table" option:
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
Solved! Go to 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
Hi, @mbregunci
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.
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.
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.
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 " " is displaying instead of bl... - Microsoft Fabric Community
I will post it here as soon as it will be fixed.
Thank you
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.