cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Eyal
Helper I
Helper I

Scatter plots from atributes

Hi,

 

I have a a large data set, arrange as a flat table that  iI use to control trends from diffrent attributes.

I want to creat a scatter plot to see the correlation between the attributes but could not figure out the orrect meassure.

Thank you

Eyal

Untitled picture.png

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

HI @Eyal ,

 

You can try to use following measures:

HeightM=
CALCULATE (
    MAX ( Table[Value] ),
    FILTER ( ALLSELECTED ( Table ), [Attribute] = "Hight" ),
    VALUES ( Table[Lot] )
)


PriceM =
CALCULATE (
    MAX ( Table[Value] ),
    FILTER ( ALLSELECTED ( Table ), [Attribute] = "Price" ),
    VALUES ( Table[Lot] )
)

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

4 REPLIES 4
v-shex-msft
Community Support
Community Support

HI @Eyal ,

 

You can try to use following measures:

HeightM=
CALCULATE (
    MAX ( Table[Value] ),
    FILTER ( ALLSELECTED ( Table ), [Attribute] = "Hight" ),
    VALUES ( Table[Lot] )
)


PriceM =
CALCULATE (
    MAX ( Table[Value] ),
    FILTER ( ALLSELECTED ( Table ), [Attribute] = "Price" ),
    VALUES ( Table[Lot] )
)

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

@v-shex-msft 

 

Thank you very much, work very welll.

 

Eyal

v-shex-msft
Community Support
Community Support

Hi @Eyal ,

 

You can create a matrix visual to achieve your requirement.

 

Steps:
1. Drag Lot to row, attribute to column, value to value field.
2. Create a slicer with source of attribute column.
3. Choose attribute value which you wanted display on matrix visual.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

@v-shex-msft 

 

I am sorry, I was not clear enough.

The issue is not to get the matrix table.  I want to create two measures that I could use for a scatter plot visual and a correlation calculation.

 

Thanks for your help

Eyal

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

html:
Carousel MBAS ARun Part 1 768x460

MBAS 2021

Join Arun Ulagaratchagan and the Power BI team at MBAS! #MSBizAppsSummit #CommunityRocks

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

Top Kudoed Authors