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

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi, 

 

Thank you for looking at this. 

 

Sadly neither of those seemed to work. As mentioned before, I have tried using the "Show items with no data", but that does nothing. 

I have also tried measrue = SUM ( 'FilteredLead'[App Ready For Credit Check] ) + 0, but again it just causes an error. 

 

I think I will have to keep searching the wonderful Power BI forum's.