Scatter plot's X axis value based on slicer/filter value pick value calculation?

[sanrajbhar]

Hello Commnunity,

is there any way to create scatter plot with x-axis value being dyanmic taking value and multplying from selected pick value(filter)?

e,g See below Snapshot, I am unpivoting three columns (3 variable you can say). I want to change the x-axis value where attribute = "N95" * selectValue from pick box. Any guidance ?

Thanks for help..!

[v-easonf-msft · Accepted solution]

Hi, @sanrajbhar 

You can try to store the factor in a variable to check if it works

Measure = 
VAR factor =
    SELECTEDVALUE ( N95_factor[Factor] )
RETURN
    SUMX (
        Table1,
        IF ( Table1[Attribute] = "N95", Table1[Value] * factor, Table1[Value] )
    )

If it doesn't meet your requirement,please provide more details about it .It you can share a sample pbix file,it will better help us for testing.

Best Regards,
Community Support Team _ Eason

[sanrajbhar]

hi,

Table1[Atrribute] is not value column , it hold string. 

calcDax = SUMX(Table1,IF(Table1[Attribute]="N95",Table1[Value]*SELECTEDVALUE(N95_factor[N95f_val]),Table1[Value]))

I want to match string rowise  if  Table1[Attribute] = "N95 " then do multiple by factor selected in pick box otherwise use the original value. Abox Dax is working in good simple dummy data. but not on actual data. it multiple strangly like, 7 * 6 = 714.

I am not sure whats goes wrong.?

[v-easonf-msft]

Hi, @sanrajbhar 

Try to create a measure as below:

Measure_Factor = SELECTEDVALUE(Factor[Factor])

Calc_Value =
VAR _val =
    IF (
        MAX ( Table1[Atrribute] ) = "N95",
        MAX ( Table1[Value] ) * [Measure_Factor],
        MAX ( Table1[Value] )
    )
RETURN
    IF ( ISFILTERED ( Factor[Factor] ), _val, MAX ( Table1[Value] ) )

For more details,please check the attached pbix file.

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.