Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 base...
Need Help
Show and Tell
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    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

     

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

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

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thank you!

     

    I was considering the same, but just wanted to make sure if I can do it with DAX.

     

    All due respect,

     

    Atanas