Forum Discussion

D4imi0n's avatar
D4imi0n
Helper I
5 years ago
Solved

Different behaviour with Table and Slicer Visuals

Hello all,

I currently facing a Power BI behavior which I can't quite explain. Maybe the solution is simple but not quite tangible for me.

I have the following model. Very simple:

In addition, I have the following page filter:
- AB_NAME from Table D_VERMITTLER_CONFORMED

- ID_ZEIT_MONAT from Table D_ZEIT_MONAT

 

What is working fine:

If I place a table visualization on the page and take columns from D_ZEIT_MONAT and D_VERMITTLER_CONFORMED the page filters are drawn correctly. The SQL looks good because Power BI understands that it should join over three tables.

 

Challenge:

If I place a slicer visualization on the page and take one column from D_VERMITTLER_CONFORMED the page filters are NOT drawn correctly. It seems that there is a problem with the ID_ZEIT_MONAT filter.

I could trace that there is a probleme with the ID_ZEIT_FILTER connection because for a test I added the field ID_ZEIT_MONAT to the slicer visualization. With this I then got the following failure:

 

You are using fields that don't have a supported set of relationships

 

My specific question is if I am doing something wrong. Perhaps it should be said that the model runs in Direct Query Mode.

 

Thank you all for your help and time.

 

 

Need Help
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    D4imi0n 

    Just out of curiosity, is there a reason you don't have a relationship between the Date Table and the D_seller table and have a separate Dimension table for D_Seller? (to avoid a potential relationship conflict). Something like this:

     

     

     

9 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hallo D4imi0n ,

     

    I checked your file, the problem is the relationship.

    In the right table you can change it to a slicer because they have a direct connection. So you can get all the years from the Date table and then filter Sales and get the related countries:

     

    The left table you can get all the years from the Date table, but then the relationship to the Geography table cannot be made. The connection would go to the Sales table and then from the Sales table to the Geography table, what is not possible because the filter direction is not allowing that:

     

    In general this is not a common way to create a hierarchy slicer. I would recommend to just add 2 slicers, one for the year and one for the Geography. 

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    Hi D4imi0n ,

     

    Would you mind providing a sample .pbix file?

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • D4imi0n's avatar
      D4imi0n
      Helper I
      5 years ago

      Hi Chen, 

      thanks for the reply. I try to append a sample pbix. 

       

      Cheers Jeffrey

      • D4imi0n's avatar
        D4imi0n
        Helper I
        5 years ago

        Hi Chen,

        sry for the delay. I was able to rebuild the problem with a import model.

         

        Power BI Sample File 

         

        If you start the sample you will see two tables. 

        Please change the tables to Slicers to see the problem. 

         

        Hopefully you can download the sample.

         

        Thanks