Forum Discussion

Eyal's avatar
Eyal
Icon for Helper II rankHelper II
4 years ago
Solved

dynamic select values from the same column to generate scatterplot

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])

Return

CALCULATE(

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])

Return

CALCULATE(

min('Table'[value]),

Filter('Table',

'Table'[Stage]=stg

&& 'Table'[Step]=stp

&& 'Table'[Sub-Step]=ss

&& 'Table'[Analysis]=ana

&& 'Table'[Parameter]=Para)
)


The issue I have is a can not combine the two masures in a single visual.
What am I missing? 

 


Thank you for your help




Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    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.

3 Replies

  • AlexisOlson's avatar
    AlexisOlson
    Icon for Super User rankSuper User
    4 years ago

    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.

  • Eyal's avatar
    Eyal
    Icon for Helper II rankHelper II
    4 years ago

    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 🙂 ?

    • AlexisOlson's avatar
      AlexisOlson
      Icon for Super User rankSuper User
      4 years ago

      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.