Forum Discussion
Helper IR Scatter chart –filter x and y from same column with different slicers
I have further investigated my problem and have come up with a workable solution. I thought I should put it forward just in case anyone else has a similar problem.
I created a table that lists the slicer parameters such that the Parameter X values repeat for all parameter y values as indicated in the table below.
Parameter_X Parameter_Y Revenue Revenue Revenue Profit Revenue Expenses Revenue Tax Revenue Wages Profit Revenue Profit Profit Profit Expenses Profit Tax Profit Wages The columns from the above table are fed into the R Scatter chart. Slicers are created for Parameter_X and Parameter_Y. This means the requires parameters are supplied to the Scatter chart code. The R code reads the required source data directly from a CSV file (using read.csv()). The X, Y data for the Scatter chart is filtered from the CSV data.
And now the Scatter chart reacts to variations in the selecter Parameter_X and Parameter_Y value.
Helper II have further investigated my problem and have come up with a workable solution. I thought I should put it forward just in case anyone else has a similar problem.
I created a table that lists the slicer parameters such that the Parameter X values repeat for all parameter y values as indicated in the table below.
| Parameter_X | Parameter_Y |
| Revenue | Revenue |
| Revenue | Profit |
| Revenue | Expenses |
| Revenue | Tax |
| Revenue | Wages |
| Profit | Revenue |
| Profit | Profit |
| Profit | Expenses |
| Profit | Tax |
| Profit | Wages |
The columns from the above table are fed into the R Scatter chart. Slicers are created for Parameter_X and Parameter_Y. This means the requires parameters are supplied to the Scatter chart code. The R code reads the required source data directly from a CSV file (using read.csv()). The X, Y data for the Scatter chart is filtered from the CSV data.
And now the Scatter chart reacts to variations in the selecter Parameter_X and Parameter_Y value.
- v-caliao-msft
Microsoft Employee
Glad to hear that your issue got solved by youself, please accecp your reply as solutiom, as you said it will help other who have the similar issue to find the solution easily.
Regards,
Charlie Liao