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 th...
Need Help
  • v-easonf-msft's avatar
    v-easonf-msft
    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

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