cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Krishna_Mysore Regular Visitor
Regular Visitor

Need help to insert space (Blank Row) in a Matrix Visual

Hello

 

I have matrix visual with metrics on the Rows as shown below. This matrix is sourced from a Table called KPI .

I would like to have blank space after each category . This I have achieved by inputting  a set of periods after each category . 

The matrix visual now gives a blank row as I wanted but the row category with the spaces does not appeal hence I'm seeking a more elegant way of inserting a blank . Any ideas?

 

Regards

K

NBO Matrix.PNGKPI Table.PNG

6 REPLIES 6
v-xjiin-msft Super Contributor
Super Contributor

Re: Need help to insert space (Blank Row) in a Matrix Visual

Hi @Krishna_Mysore,

 

=> This I have achieved by inputting  a set of periods after each category .

 

What is the category? What's the relation between category and table KPI?

 

Could you please share us your pbix file with OneDrive or Google Drive if possible? It will help us more to understand your requirement.

 

Thanks,
Xi Jin.

Krishna_Mysore Regular Visitor
Regular Visitor

Re: Need help to insert space (Blank Row) in a Matrix Visual

Hi @v-xjiin-msft

 

Link to the PBIX file

 

https://1drv.ms/u/s!AilocBFrwwn5gSJbe0MXicxDvl7b

 

Thanks

Krishna

v-xjiin-msft Super Contributor
Super Contributor

Re: Need help to insert space (Blank Row) in a Matrix Visual

Hi @Krishna_Mysore,

 

First, thanks for sharing your pbix file. 

 

 

However I still don't understand about "This I have achieved by inputting  a set of periods after each category. The matrix visual now gives a blank row as I wanted but the row category with the spaces does not appeal".

 

What are the categories? Did you mean [Site Description]? For your current Matrix, you can select the Expand all down one level in the hierarchy option to display the [Site Description]. And the blank space is still here.

 

7.PNG

 

Thanks,
Xi Jin.

 

Krishna_Mysore Regular Visitor
Regular Visitor

Re: Need help to insert space (Blank Row) in a Matrix Visual

Hi @v-xjiin-msft

 

Please refer to my original post with images where I have highlighted the matrix table where I have inserted dots as field name under the KPI Table. This enabled me to insert blanks in the matrix table, howerver is there an option to get away by not inputting dots yet insert blank?

 

Hope this is clear!

 

 

 

 

v_krishna Member
Member

Re: Need help to insert space (Blank Row) in a Matrix Visual.

Hi ,

 

I was going through your post and observed the sample PBI file shared. 

 

Need help on a similar scenario where i need to display the Blank rows in Matrix Visual. I have posted my request and below is the link.

 

https://community.powerbi.com/t5/Desktop/Need-help-on-designing-Visual/m-p/561243#M264742

 

Thanks.

v_krishna Member
Member

Re: Need help to insert space (Blank Row) in a Matrix Visual.

I have explored and Found solution to display the blank rows  in the Matrix visual ( i.e. display the rows  which has no values)

 

Refer the post  i submitted for more details (https://community.powerbi.com/t5/Desktop/Need-help-on-designing-Visual/m-p/561243#M264742)

 

Solution:

 

 Rows  -->  select the Row field and right click and choose "Show items with no data" option.

 

Same applies to,

 

Columns --> select the Column field and right click and choose "Show items with no data" option.

 

Refer the below working visual:

 

Item5 has blank values but still the entire Item5 Row is displayed in the Matrix visual. 

 

DisplayBLANKROWSCapture.PNG