Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Scatter plot chart X and Y axis dynamic.

Hi all,
I am trying to plot scatter chart Y and X axis dynamic whereas if filter is selected it should go to ‘Device’ level and select all selected it should go to ‘Total level of data.

Date

Home_Number

Device

Attributed_Members

CD

VD

05/08/2022

1000130

Total

1

1

1

05/08/2022

1000139

PC

1

3

2

05/08/2022

1000130

Total

2

1

2

05/08/2022

1000139

Total

2

8

5

05/08/2022

1000130

UNCLASSIFIED

2

 

1

05/08/2022

1000139

Total

1

8

5

05/08/2022

1000139

TABLET

1

1

1

05/08/2022

1000139

SMARTPHONE

2

4

2

05/08/2022

1000130

TABLET

1

1

1

05/08/2022

1000139

SMARTPHONE

1

4

2

05/08/2022

1000139

PC

2

3

2

05/08/2022

1000139

TABLET

2

1

1

05/08/2022

1000130

TABLET

2

1

1

 

My requirement is to plot scatter chart on X axis it should be CD and Y axis should be VD.
when user select ‘Select all’ from the filter it should show CD and VD as per given values in respective columns.

if user select any filter from the device PC it should show the pc data but if user select multiple filter from the device like PC and smartphone it should group Home and attributed_member column and CD column should be summed here on home and attributed member level like 1000139 home number and attributed member 1 CD should be 7 and VD should be show 5. Should show on graph. We need to show X and Y axis both dynamic.

I am able to perform group and aggregation by using sumx and summarize formula but not able to show it on graph.
but without showing  home and attributed member on graph, Is it possible to show aggregation on each home and attributed member x and y axis?

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

    Please try below steps

    1. my test table

    Table:

    2. create a new table by below dax formula

    Table 2 =
SUMMARIZE (
    'Table',
    'Table'[Hone_Numbe],
    'Table'[Device],
    'Table'[Attributed_Members],
    "Sum_For_CD", SUM ( 'Table'[CD] ),
    "Sum_For_VD", SUM ( 'Table'[VD] )
)

    Table2:

    3. add slicer and scatter chart visual

     

    Please refer attached .pbix file

     

    Best regards,
    Community Support Team_ Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous ,

    Please try below steps

    1. my test table

    Table:

    2. create a new table by below dax formula

    Table 2 =
SUMMARIZE (
    'Table',
    'Table'[Hone_Numbe],
    'Table'[Device],
    'Table'[Attributed_Members],
    "Sum_For_CD", SUM ( 'Table'[CD] ),
    "Sum_For_VD", SUM ( 'Table'[VD] )
)

    Table2:

    3. add slicer and scatter chart visual

     

    Please refer attached .pbix file

     

    Best regards,
    Community Support Team_ Binbin Yu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.