Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |