Help regarding slicer relationship

[Anonymous]

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?

[selimovd]

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

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

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

[v-deddai1-msft · Accepted solution]

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