Forum Discussion
Insert a blank row in matrix visualization
it will if you create it with a category and blank products
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?
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.
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
Yes right. Its ignoring the blank values. I have already tries with space bar characters but the output remains the same.