Forum Discussion

pibou's avatar
pibou
New Member
8 years ago
Solved

remove filter to display null values

this looks like very simple and I cannot manage to do it.   this is an excel file wave division score v1 d1 5 v1 d2 6 v2 d1 7   now I use two table controls in power view....
Need Help
  • BILASolution's avatar
    BILASolution
    8 years ago

    Hi pibou

     

    To achieve this, you can create a new table with distinct values of "Wave" column.

     

     

     

    Then, use the "Wave" column from Wave table to put it into a table in power view.

     

     

     

    I hope this helps

     

    Regards

    BILASolution

BILASolution's avatar
BILASolution
Solution Specialist
8 years ago

Hi pibou

 

To achieve this, you can create a new table with distinct values of "Wave" column.

 

 

 

Then, use the "Wave" column from Wave table to put it into a table in power view.

 

 

 

I hope this helps

 

Regards

BILASolution

pibou's avatar
pibou
New Member
8 years ago

dear BISolution

 

firstly, many thanks having taking your time to reproduce the example ! And it works perfectly fine. I should have thought to do that too.

 

I am not toally sure why this works, even if I understand that a measure cannot do that, because it is affecting the key figure (the value), not the category wave. But why a tabke with a strong relationship is any different, the context restricts the rows in the same manner. But never mind, I am totally satisfied !

 

Best

 

Bruno