1 of 1 people found this helpful
Unique problem you have there! The simplest way to get there might be pivoting your data source. As to not mess up other dependent sheets, duplicate your data source. Go to the data source pane, right click, and pivot 3 of your measures. You'll get 2 pivot fields. Rename these appropriately. Next, pivot your next grouping of 3 measures, and rename these appropriately. Now you can use these pills, one of each of the pivot field values on rows, and pivot field names on color on each of the marks cards.
That should work, let me know if you need any additional guidance!
can you attach your workbook so that you can solve your problem please
Galen Busch Well I thought that worked because the new viz looked perfect. However, every time I create the Pivot, the other worksheets in my workbook become distorted/lose data. I've tried duplicating my data source but that doesn't seem to help. What is the best way to do that?