Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
ankit2747
Frequent Visitor

Insert a blank row in matrix visualization

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".

 

CategoryProductAmount
C1P11000
 P21500
 P31800
   
C2P41200
 P51300

 

 

Thanks,

Ankit

18 REPLIES 18
Jason-Craft
New Member

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
Frequent Visitor

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.

blank rows.jpg

sebouier
Frequent Visitor

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
Kudo Kingpin
Kudo Kingpin

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
Super User
Super User

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

 

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





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Hello,

 

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

Can you please explain. 

 

Thanks!!

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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.  





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




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





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




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.  

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?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




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:

 

CategoryProductAmount
C1P11000
C1P21500
C1P31800
C1  
C2P41200
C2P51300

 

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.

matrix1.png

 

 

 

 

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   

 

 





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




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

ankit2747
Frequent Visitor

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".

 

CategoryProductAmount
C1P11000
 P21500
 P31800
   
C2P41200
 P51300

 

 

Thanks,

Ankit

I am not aware of a way to do that.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.