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 "European Plants".

 

I want to create a slicer with column B, named European Plants, so that when I click on a plant inside this slicer, column A gets filtered by my selection.

 

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 "European Plants".

 

I want to create a slicer with column B, named European Plants, so that when I click on a plant inside this slicer, column A gets filtered by my selection.

 

What I did was creating a relationship between column A and B, the problem is that all the values from column A which do not have a match, so all the Not Europeans plants, are collected into a new raw (Blank) in the slicer, and that is really annoying to see.

 

Do you have an idea about how to solve it without removing raws or adding a special value Unkown inside column B?

 

It seems to me a pretty standard scenario and I would be surprised if there is no easy way to solve it.

 

Thank you a lot!

 

 

Need Help

3 Replies

  • 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