Forum Discussion

jtomczyk's avatar
jtomczyk
Helper I
4 years ago

scatter chart

Hi,

Do you have any idea how to create a scatter chart for below data? The axis are not numerical.

I would like to present what is the most common pair of car's engine and car's color.

 

Scatter chart proposal

 

Data format

VINEngineColor
AAAZZZ011.2 CBZABlue
AAAZZZ021.2 CBZBGreen
AAAZZZ032.0 CBDCSilver
AAAZZZ042.0 CBAA Black
AAAZZZ051.4 CAVDWhite
AAAZZZ061.6 CAYBGold
AAAZZZ071.6 BSERed
AAAZZZ081.6 CAYCBlue
AAAZZZ091.8 CDAAGreen
AAAZZZ102.0 CBDCSilver
AAAZZZ112.0 CBAA Black
AAAZZZ122.0 CBDB White
AAAZZZ132.0 CBBBGold
AAAZZZ142.0 CBFARed
AAAZZZ152.0 CCZBBlue
AAAZZZ162.0 CDLGGreen
AAAZZZ172.0 CBDCSilver
AAAZZZ182.0 CBAA Black
AAAZZZ192.0 CCZBWhite
AAAZZZ202.0 CDLGGold
AAAZZZ211.2 CBZBRed
Need Help

3 Replies

    • jtomczyk's avatar
      jtomczyk
      Helper I
      4 years ago

      Hi Pat,

      Thanks for prompt reply. I have tried that. Unfortunetly it does not work as I would like.

       

      Here are the screen shot of the chart when puting 

      Primary Key VIN

      X category Color

      Y category Engine

      Value VIN

       

       

      However accoding to the data

      Engine 1 with black should have one circle with size 2

      Engine 2 with black should have one circle with size 1

      Engine 3 with white should have one circle with size 2

      Engine 4 with black should have one circle with size 5 and have one circle with size 3

      Engine 5 with white should have one circle with size 1 

       

      like that

      I have tried to change that but without success... Any idea why it is like that?

       

      Can you please let me know how to edit XYCategory.pbiviz ?