Forum Discussion
Blank Values in Dimension Table
Dear Community,
I have blank values in my data model and i would really like to get them away, or replace them with "No Information"
This is my data model:
When i create a pivot based on Supplier type though i know i don't have information for all the types and i might have some blanks as it happened already. When i drop the paid amount measure in the filter context of supplier type this is what i get:
Is there a way to tell excel (power BI) to replace the blanks with "No Information"?
Thank you in advance,
Atanas
The reason you have blank there is that there are supplier types in the table with paid amount that are not in the table with the supplier type column. If you want to eliminate those from the visual, click on the visual/highlight it and on the Filter panel just use the filter for that colum to deselect Blank.
Or you can do additional work on your model so that all supplier type values appear on both sides of the relationship.
Regards,
Pat
2 Replies
The reason you have blank there is that there are supplier types in the table with paid amount that are not in the table with the supplier type column. If you want to eliminate those from the visual, click on the visual/highlight it and on the Filter panel just use the filter for that colum to deselect Blank.
Or you can do additional work on your model so that all supplier type values appear on both sides of the relationship.
Regards,
Pat