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 all
I have the following scenrio:
I a have a single table with multipl colmuns for the diffrent parmater anlysed doring the meny step of a process.
I want to be able to generate a corolation (scatterplot) by dynamic selection, so the user can analys what ever combination he likes.
I genreted a 2nd table (a opy of the first) so i can have 2 no related slicers.
to get the selected value i used this measure :
X value =Var Stg= SELECTEDVALUE('Table'[Stage])VAr STp= SELECTEDVALUE('Table'[Step])Var SS= SELECTEDVALUE('Table'[Sub-Step])var ana=SELECTEDVALUE('Table'[Analysis])var Para=SELECTEDVALUE('Table'[Parameter])ReturnCALCULATE(min('Table'[value]),Filter('Table','Table'[Stage]=stg&& 'Table'[Step]=stp&& 'Table'[Sub-Step]=ss&& 'Table'[Analysis]=ana&& 'Table'[Parameter]=Para)) | Y value =Var Stg= SELECTEDVALUE('Table 2'[Stage])VAr STp= SELECTEDVALUE('Table 2'[Step])Var SS= SELECTEDVALUE('Table 2'[Sub-Step])var ana=SELECTEDVALUE('Table 2'[Analysis])var Para=SELECTEDVALUE('Table 2'[Parameter])ReturnCALCULATE(min('Table'[value]),Filter('Table','Table'[Stage]=stg&& 'Table'[Step]=stp&& 'Table'[Sub-Step]=ss&& 'Table'[Analysis]=ana&& 'Table'[Parameter]=Para) |
Solved! Go to Solution.
I'd recommend two independent parameter tables (with no relationships to other tables) for selecting X and Y and then using those two selections to filter a single set of fact and dimension tables. This avoids the problem you have where the Lot1 and Lot2 rows are coming from different tables and thus don't work in a combined visual.
@AlexisOlson thank you this work great!!
I am couriuse is there a way to get to the same result using just a single table and single slicer with multiple selection? anyone up for the chalenge 🙂 ?
I'm not sure it's a great idea but you could allow multiple select from a single independent parameter table and use MIN/MAX to separate the selection choices.
I'd recommend two independent parameter tables (with no relationships to other tables) for selecting X and Y and then using those two selections to filter a single set of fact and dimension tables. This avoids the problem you have where the Lot1 and Lot2 rows are coming from different tables and thus don't work in a combined visual.
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 |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |