Forum Discussion
Power Query shows null and table visual shows blanks
Hi Beth_H ,
According to your statement, I think Power BI will show blank when there is no data in text type column.
Then Power BI will only show only once if multiple rows' data are the same. This is by design and is better for us to show different data.
So your visual will look like as:
RecordId Agency 1 1 Blue 2 2 Red 3 4 4 Orange
It is better for you to add a unique key column to expand your visual, such as [Id] column.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I made a matrix, but there are many 'null's in the matrix.
I use the 'Filters' pane below.
Thank you but this isn't quite the issue.
When I pull into the table visual, the table doesn't show nulls, it shows blanks. All nulls have disappeared. So your first matric doesn't look like what I have.
And, if I try your solution and apply the filter 'Agency is not blank', then when I pull in additional fields I get this result.
| RecordId | Agency | Location | Extension | Department |
| 1 | Blue | |||
| 2 | Red | |||
| 4 | Orange |
I copy your text data in the web page.
These 'null' data are Text-type data in my matrix.
In Excel sheet, when you don't input any data and format some cells, these cells are 'blank' data not 'null' data.
How about your 'null' data?
Don't you format some cells?
For example, border line...