Tables in online service showing (blank)

[jcarville]

As of this morning tables that we have in the online version of our reports show (blank) where before they were just empty.

This is making our report look very untidy, has anyone else experienced this?

I presume its something to do with the monthly update.

[Anonymous]

This is still a problem.

It makes the tables super ugly. Please fix.

[Vicky_Song]

@Anonymous, @jcarville, @Tishchenko, @Anonymous, @srutt, this issue should be already fixed. Please have a check on it, and post back once you still any further questions. 

[Vicky_Song]

@jcarville, @Anonymous, @srutt, @ankitpatira, @Tishchenko, thank you all for your feedbacks. I will report your issue internally and will post back once I get any updates. Sorry for any inconvenience you may have. 

Currently, I think you could consider using @jcarville 's idea to replace empty data with a blank space, this method will remove the (blank) text from visualization. 

[Tishchenko]

In my fact tables has no null values! My (blank) is "calculated" by server for example when use one dimemsion and put measures from two different FACT tables in one "table visual". Dimension table has relationships with two fact tables (one to many). 

So, this (blank) cells is calcutated "on fly" by SSAS server.

[jcarville]

The solution that seems to work for me is to edit queries, select all of my columns and then replace values.

Type null in "Values to Find" and type press ok. This should replace all null values with a blank space.

Also I am using a table for this, not sure if it will work for a Matrix.

[Anonymous]

Every one is facing the issue.. The update is in cloud display of visualization.

It is the sad & irritating update from Power BI team. Showing (Blank) for each cell where there is no data makes tables look ugly.

POWERBI TEAM - PLEASE REVERT TO ORIGINAL like it is showing in PBI desktop

To members:-

Only workaround is to change the visualization to Matrix, though it is not ideal one

Another one is tough, writing DAX for each column with ISBLANK() function

Arup

[srutt]

I'm experiencing the same issue as of this morning.

[ankitpatira]

@jcarville edit your report in power bi service and for fields shown in tables, untick show items with no data. This should take blanks away.

[jcarville]

Thanks for that @ankitpatira but your solution does not seem to resolve my issue as show items with no data is already unticked.

[ankitpatira]

@jcarville i can reproduce your issue. it seems like a bug. workaround for it would be to edit that report in power bi service, drop that field into filter and then exclude blank values like in screenshot below. I would also report this issue.

[jcarville]

I have reported the issue there now through the send a frown option.

When I do the 2nd way you suggest @ankitpatira it loses its formatting and is making all cell values have no value even if it does contain a value.

[Tishchenko]

New build PowerBI service from 2016-05-26(13.0.1100.658)  = new problems 😉

Can I hear the name of the man from BI team who invented it ??? my users write him "thanks" and other unpleasant expletives