Forum Discussion

alecalma's avatar
alecalma
Regular Visitor
7 years ago

Relationship and (blank) problem

Hi everyone, I have a problem.   Let's say I have in my big dataset a column A with different plants from all over the world. I also have another master table with a column B which is called "Euro...
Need Help
snandy2011's avatar
snandy2011
Helper IV
7 years ago

Hey alecalma,

 

It can be two ways to solve this problem, Easy way to make column B report level filter and deselect Blank Value,

 

Second way to modify the relationship.

 

Below is my try,

 I have taken two column (A and B) as separate datasets, made column B as Slicer, then modified the relation as many to one.Check out  the screenshots please,

 

 

Hope it will help you.Please let me know for any more clarification.

 

Thanks,

Snandy2011

alecalma's avatar
alecalma
Regular Visitor
7 years ago

Hi snandy2011, thank you a lot.

 

The first option works and it could be a walkaround, but for the second one, I do exactly what you do and I get an additional blank inside B after I create the relationship.

 

Maybe there is something i am not getting? 

  • snandy2011's avatar
    snandy2011
    Helper IV
    7 years ago

    Hi alecalma,

     

    It should not return any blank..

    can it be possible to share any screenshots and some sample data?

     

    Thanks,

    snandy2011