Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Columns removed when no data present

Hi,   I am really new to the world of Power BI, so sorry if I am asking stupid questions.    I am trying to use the matrix visualization to show a persons name in the row and day of the week in t...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    7 years ago

    hi, Anonymous 

    I didn't notice that From your screenshot, there is no dim Day of the week table that leads to this case.

    So just create a dim Day of the week table and then create a relationship with FilteredLead table.

     

    When create the visuals, please use Day of the week filed from Dim table instead of FilteredLead table.

    Then use the above way and it should work well.

     

    Best Regards,

    Lin

     

v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, Anonymous 

I didn't notice that From your screenshot, there is no dim Day of the week table that leads to this case.

So just create a dim Day of the week table and then create a relationship with FilteredLead table.

 

When create the visuals, please use Day of the week filed from Dim table instead of FilteredLead table.

Then use the above way and it should work well.

 

Best Regards,

Lin