Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello all,
I'm having some issues with my data model. I'm trying to create a relationship between 3 tables (pictured below):
The issue I'm running into is that when I create a visualization, only one line on the graph responds to a slicer selection (the slicer selection is WLOC which appears in all 3 tables).
The lines on the line graph use the dimensions, 'Match %' from the 'EDW Query' table and 'Average lux' from the 'ambient lux - 1hr block' table. The line graph's x-axis is the 'Hours' dimension. In the above pictured relationship I joined the tables using the 'Hours' dimension.
Essentially, what I want is to be able to select any WLOC in the slicer and ensure that the 'Match %' line and the 'Average lux' line both respond to the slicer selection.
I found that when I make the relationship connection based on WLOC the slicer works, but in that case, one of the lines on the visualization will be completely straight (the one that is not entered into the X-axis field).
This example applies to the relationship between the 'EDW Query' Table and the 'ambient lux - 1hr block' table, but I also want to have a responsive visualization when i select a WLOC in the slicer where the visualization contains 'Match %' and 'Average of rH' and 'Average of Temp' from the 'ambient C_rH 1hr block'.
Hope that makes sense, if not I can clarify
Hi @Rwars065,
Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
89 | |
84 | |
76 | |
64 |
User | Count |
---|---|
135 | |
112 | |
98 | |
98 | |
92 |