Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I'm very new to PowerBi and would like to explore the possibilities with it.
I'm working on a small project where I created multiple weather stations equipped with sensors.
All data is stored into the following overview:
What I've done so far in a report:
I added next a functionality to drillthrough from graph 1 by using the forcasting (returns WeatherStationName)
Now I want to fill the second report with the same graphs. The forecasting curve went easily. How could I filter the slicer containing sensors to only a selection of sensors that are equiped on the Weather Station? Graph 2 has to show the raw values of sensors inside this list (which can be filtered by the user as well).
Concrete actions should be:
So I'm a bit stuck as of step 2. Am I still correct that I should use DAX to get this done? If so, would you have any idea on how to do this exactly?
Thanks in advance!
Hi Tie-Tie,
You should build a relationship based on StationID column from table WeatherStation to table StationSensorMap, then you can use slicer or DAX function measure like related to filter StationID in StationSensorMap.
In addtion, make sure there's no duplicate values in StationID column.
Hope this can help.
Jimmy Tao
Hi Jimmy,
Thanks for your reply.
the relationship you proposed would be a many-to-many relationship, so I guess this will not work out?
The image above shows all one-to-many relationships
Best,
Tie-Tie
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |