Forum Discussion
Scatter plot changing based on slicer selection
Community SupportHi 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