Scatter plot chart X and Y axis dynamic.

[Anonymous]

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?

[Anonymous · Accepted solution]

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.