Show entire row as a blank row in the report in Matrix Visual

[filexsundeep09]

Experts, how to show an entire blank row in the Visual matrix as per the below snapshot.

[Anonymous · Accepted solution]

Hi  @filexsundeep09 ,

I created some data:

Here are the steps you can follow：

Create calculated table.

Table2 =
var _table=
SUMMARIZE('Table',
'Table'[Date],"Group"," ","Amount",BLANK())
return
UNION('Table',_table)

Because Power BI is sorted alphabetically, when it is blank, it will automatically display to the top

If you want to display it below a certain column, you can name it as the character in front of the column, followed by a space

for example

Table2 =
var _table=
SUMMARIZE('Table',
'Table'[Date],"Group","C_BLANK","Amount",BLANK())
return
UNION('Table',_table)

If you need pbix, please click here.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[technolog]

I think you can try create blank measures 

blank_measure = BLANK()

then add measure to visualization and set her name to empty or space