Forum Discussion
Slicer to switch between multiple columns in chart
Hello
I've a "Test Cases" SP list which contains a couple of 100's line items (test cases). The list contains columns for:
- title
- description
- result
- test case ID
- plus multiple columns for the status of the current test iteration.
In total there are 8 status columns like:
- Status-1
- Status-2
- ...
The status columns are choice fields:
- 01 - Not Started
- 02 - Failed
- 03 - Successful
- 04 - Not Required
- 05 - Retest
What I want to achive is to have a slicer, which includes the Iterations (1,2,3,4,5,6,7,8,All). When I select the "1", then I want a pie chart, which shows the number of test cases from the 1st iteration according the value 01 - Not Started, 02 - Failed, ...., means from coloum Status-1. If I select the "2" on the slicer, then I want that the same pie chart shows the number of test cases from the 2nd iteration according the value 01 - Not Started, 02 - Failed, ...., means from coloum Status-2. How can I do this, means how the switch between all 8 columns and show the results
mariobeiutz I would recommend unpivoting your status columns in Power Query and then it should be straight-forward.
4 Replies
- Greg_Deckler
Community Champion
mariobeiutz I would recommend unpivoting your status columns in Power Query and then it should be straight-forward.
Dear Greg, thank you so much, so simple and it did the trick. Cheers Mario
v-kkf-msftCommunity Support
Hi mariobeiutz ,
Did Greg_Deckler 's reply solve your problem? You can unpivot the columns as he said. If it is solved, please consider accept Greg_Deckler 's reply as the solution to help the other members find it more quickly.
Best Regards,
WinnizHi, yes Greg's solution is working, thank you too for the sample you sent. Cheers Mario
