Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Eyal
Helper II
Helper II

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? 

Eyal_0-1633550264189.png

 


Thank you for your help




1 ACCEPTED SOLUTION
AlexisOlson
Super User
Super User

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.

View solution in original post

3 REPLIES 3
Eyal
Helper II
Helper II

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

AlexisOlson
Super User
Super User

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.