Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I am trying to filter data based on several filters which doesn't work since only one of my relationships can be active. Is there a workaround for this? Or does anyone have any tips on how I can tabulate my data better to achieve my end goal?
Essentially I've got tables containing data about the temperature and CO2 level in a specific room with all the data points time stamped. I have also created a master date+time table. What I want is for the user to be able to choose a building/room and also a date/time interval. The line chart should then reflect this filtering and only contain lines from the given rooms in the given time frame.
This is the master time+date table and an example of a table with temperature and CO2 data from one room:
I also have a table containing all the room numbers for the given building that looks something like this:
Building | Room |
511 | 51101023 |
511 | 51101024 |
511 | 51101025 |
511 | 51101026 |
Solved! Go to Solution.
Hi @Anonymous ,
The relationship I modeled is the [room] field of the building and room table and the room field of the CO2 and temperature table. Where the building and room table is on one end. They are in an active relationship as shown below.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
According to your description, here are my steps you can follow as a solution.
(1) My test data is the same as yours.
(2) Click "transform data" to enter the power query, copy the datetime column of the [temperature and CO2] table, then split it, delete the redundant columns and leave the time column.
(3)We can create two tables and build the relationship as follows.
Building Table = VALUES('building and room Table'[Building])
Time Table = VALUES('time+date table'[Time])
(4) Then the result is as follows.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-tangjie-msft , thank you!
How should the relationships be set up when including CO2 and temperature tables for the other rooms if I want them all to be active simultaneously?
Hi @Anonymous ,
The relationship I modeled is the [room] field of the building and room table and the room field of the CO2 and temperature table. Where the building and room table is on one end. They are in an active relationship as shown below.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |