Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Help regarding slicer relationship

Hi, I was working on the Slicer name Month.  It will filter the values of 3 tables using Month and I got the month values using Distinct Union of Month from these 3 tables and created 1:M relationship but it is not working. It only filters one table 

Can anybody help me?

 

Need Help
Show and Tell
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi Anonymous ,

     

    In your screenshot, you only have an active relationship between "Month Slicer" and "WalkTest_DB_Data", so your slicer could only filter the "WalkTest_DB_Data". You can try to use TREATAS function or USERELATIONSHIP function in your measure or you can even create a visual level filter based the value of "Month Slicer"

     

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

     

    Best Regards,

    Dedmon Dai

3 Replies

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    5 years ago

    Hey Anonymous ,

     

    when the lines in the relationship model are dotted, they are not active. Actually you only have a relationship between "Month Slicer" and "WalkTest_DB_Data", the other two relationships are inactive and for that reason won't work.

     

    In general you do a lot of many to many relationships what will cause you problems when analyzing. Like for example now with the month table.

    Try to model your data into dimensional and fact tables. Then you won't have issue analyzing your data. Maybe check the following articles on how to do that:

    Basics of Modeling in Power BI: What is a Dimension Table and Why Say No to a Single Big Table - RADACAD

    Understand star schema and the importance for Power BI - Power BI | Microsoft Docs

     

    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
     
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      The problem is I have 3 Tables with different datas. I cannot connect them so it won't matter anyway

      • v-deddai1-msft's avatar
        v-deddai1-msft
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi Anonymous ,

         

        In your screenshot, you only have an active relationship between "Month Slicer" and "WalkTest_DB_Data", so your slicer could only filter the "WalkTest_DB_Data". You can try to use TREATAS function or USERELATIONSHIP function in your measure or you can even create a visual level filter based the value of "Month Slicer"

         

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

         

        Best Regards,

        Dedmon Dai