Forum Discussion
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. Dat...
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.
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.