Forum Discussion
Scatter chart comparison using 2 slicers
Hi, I am trying to replicate the image below (which I put together in paint quickly) to show the Avg. order value against no. of orders. I have 2 tables (Items table, Orders table), ...
Hi jcarville,
Based on my assumption, [Item1] and [Item2] are two separate columns in 'Item' table. If so, you could "Unpivot" these two columns to make all available items to be displayed in a single column, so that you could later add this column as scatter chart legend and add it to slicer.
Regards,
Yuliana Gu
Greg_Deckler, thanks for the tips, I have edited my original post to be more clear.
v-yulgu-msft, I appreciate your reply, but my items are in 1 column. My original post should hopefully be easier to understand.
