Forum Discussion

sanrajbhar's avatar
sanrajbhar
Frequent Visitor
5 years ago
Solved

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

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

Need Help

3 Replies

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    5 years ago

    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.

  • sanrajbhar's avatar
    sanrajbhar
    Frequent Visitor
    5 years ago

    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's avatar
    v-easonf-msft
    Community Support
    5 years ago

    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