Forum Discussion
Scatter plot changing based on slicer selection
Hi Anonymous ,
Can you provide some sample data with measure,calculated column to make it easier to test?
Much appreciated.
Best Regards,
Kelly
Company Intensity Selection Value Company 1 A 1 Company 2 A 2 Company 3 A 3 Company 1 B 4 Company 2 B 5 Company 3 B 6 Company 1 C 7 Company 2 C 8 Company 3 C 9 Company 1 D 10 Company 2 D 1 Company 3 D 2 This is the data for the y-axis. The slicer has intensity selection and if you select A only a sum of those values are shown on the graph aggregated by company. This is a column (no measures in this table).
The X-axis has this data
Company Feature Value (Measure) Company 1 x 3 Company 2 y 2 Company 3 z 4 Company 1 x 5 Company 2 y 3 Company 3 z 4 Company 1 x 5 Company 2 y 6 Company 3 z 4 Company 1 x 3 Company 2 y 2 Company 3 z 4 in the drop down you select all the features and those will be used in the measure to calculate the value column. Plotting this on the scatter graph doesnt work as shown in the screenshots above. the total of the value column is plotted for all companies (I cant click 'dont summarize as its a measure). When I made this measure a column, I was able to click 'dont summarize' but now the values dont update.
Thank you
Hi Anonymous ,
Sorry but I cant reproduce your senario based on your data,see below:
Can you deploy the chart in my .pbix file?Better advise me what measure or calculated column you are using.
Best Regards,
KellyDid I answer your question? Mark my post as a solution!