Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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:
Understand star schema and the importance for Power BI - Power BI | Microsoft Docs
The problem is I have 3 Tables with different datas. I cannot connect them so it won't matter anyway
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
78 | |
75 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |