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 (...
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.

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.