Forum Discussion

javif_84's avatar
javif_84
Helper I
1 year ago
Solved

Scattered plot map

Hi all

 

I added in a dashboard a scattered plot map. Is there any possibility to add the values of the X and Y Axis clode to the name or inside the bubble

 

Many thanks!

 

Best

Javier

 

 

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi javif_84 ,

     

    Thanks for the reply from ChielFaber .

     

    Scatter chart don't do what you need directly, I have an alternative.

     

    Here is my example data:

    Name

    X_Value

    Y_Value

    Category

    Point A

    10

    20

    A

    Point B

    15

    25

    B

    Point C

    20

    30

    A

    Point D

    25

    35

    B

    Point E

    30

    40

    A

     

    If you use a Scatter chart directly, the page will look like this:

     

    Create a calculated column:

    CustomLabel = 'Table'[Name] & " (" & 'Table'[X_Value] & ", " & 'Table'[Y_Value] & ")"

     

    Drag the created calculated column onto Values and the final page result looks like this:

     

    The pbix file is attached.

     

    If you have any other questions please feel free to contact me.

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi javif_84 ,

     

    Thanks for the reply from ChielFaber .

     

    Scatter chart don't do what you need directly, I have an alternative.

     

    Here is my example data:

    Name

    X_Value

    Y_Value

    Category

    Point A

    10

    20

    A

    Point B

    15

    25

    B

    Point C

    20

    30

    A

    Point D

    25

    35

    B

    Point E

    30

    40

    A

     

    If you use a Scatter chart directly, the page will look like this:

     

    Create a calculated column:

    CustomLabel = 'Table'[Name] & " (" & 'Table'[X_Value] & ", " & 'Table'[Y_Value] & ")"

     

    Drag the created calculated column onto Values and the final page result looks like this:

     

    The pbix file is attached.

     

    If you have any other questions please feel free to contact me.

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!