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