Forum Discussion
Insert a blank row in matrix visualization
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.