Insert a blank row in matrix visualization

[ankit2747]

Hello,

Here is a scenrio. Any help is appreciated!!!

I want to insert a blank row btween my each instance of group in matrix visualization. 

Please refer to the below snapshot. Currently  when I use matrix, "C2" details are printed from the next line. I want the blank row as show in the screenshot just before details of "C2".

Category	Product	Amount
C1	P1	1000
	P2	1500
	P3	1800
C2	P4	1200
	P5	1300

Thanks,

Ankit

[Jason-Craft]

Hello,

Add a new blank row to your category column and make sure it is ordered to be between C1 and C2. Ensure that the matrix is set to show that new category. Then right click the category field on the matrix visuals rows section and select "show items with no data."

[JMD22Si]

I just created a new measure of whatever (count of x = 1) and formatted the text and the background accordingly - quite happy with it.   FYI, I'm not totalling my rows.

[sebouier]

Here's a workaround:

- Choose a matrix visual

- Add a subtotal row

- Empty its name (usually "Total")

Then, you have to modify your measure: 

IF(HASONEVALUE([Product]),

[Amount],

BLANK()

)

[mwadhwani]

Hello ,

Category C1 is appearing only once, in my case its appearing for each row.

Can you please help me how to achieve it.

Thanks.

[vanessafvg]

could you use a union statement to add a blank row?

https://msdn.microsoft.com/en-us/library/dn802530.aspx

[ankit2747]

Hello,

Union is used to create a join of two tables. Are you suggesting to take a blank table?

Can you please explain. 

Thanks!!

[KHorseman]

I think that suggestion was based on a misunderstanding of what you were asking for...

[vanessafvg]

the suggestion was based on using any work around possible to create your blank line, if it means creating a blank table then the suggestion remains, if you find a way to make it possible,  but it does seem like an odd requirement, probably not line line with much best practise in my personal opinion.  

[KHorseman]

But the blank line is supposed to be between each category row in a matrix visual. A blank line in a data table won't have any affect on that.

[vanessafvg]

it will if you create it with a category and blank products

[ankit2747]

I tried your suggestion by adding a blank row in table. The row has value "C1" for "Category" and other fields are blank.

It's not working.  

[vanessafvg]

was worth a try, maybe put a white space in it?  dont know if that will help though.  when you say it doesn't work, what exactly happens?  Did you create all the columns, i think you need all the columns present for a union

what are you actually trying to do though, just create space as in formatting?

[ankit2747]

I have inserted a new row in my excel sheet. I have only inserted value for "Category column" and rest columns are blank. Please see below for reference:

Category	Product	Amount
C1	P1	1000
C1	P2	1500
C1	P3	1800
C1
C2	P4	1200
C2	P5	1300

Now I am trying to display this data in matrix. I have added "Category" and "product" to my "row" section and "Amount" to "values" section.

It;s showing the data perfect except a blank row between C1 and C2 grouping. I have attached snapshot of output as well. See if it helps.

[vanessafvg]

so its ignoring the blank is what you saying?   its grouping on what actually has values, the blank doesn't have a value, its empty, i still think if you force a blank character in there it might make a difference, although i have no idea how to do that in power bi  - maybe create 3 spaces with the space bar   

[ankit2747]

Yes right. Its ignoring the blank values. I have already tries with space bar characters but the output remains the same.

[ankit2747]

Hello,

Here is a scenrio. Any help is appreciated!!!

I want to insert a blank row btween my each instance of group in matrix visualization. 

Please refer to the below snapshot. Currently  when I use matrix, "C2" details are printed from the next line. I want the blank row as show in the screenshot just before details of "C2".

Category	Product	Amount
C1	P1	1000
	P2	1500
	P3	1800
C2	P4	1200
	P5	1300

Thanks,

Ankit

[Greg_Deckler]

I am not aware of a way to do that.

[KHorseman]

If you don't need totals in this matrix you could leave totals on and format all the columns so the totals are the same color as the page background. Otherwise no I don't think there's a way to do this in a matrix visual.