Slicer to switch between multiple columns in chart

[mariobeiutz]

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

[v-kkf-msft]

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,
Winniz

[mariobeiutz]

Hi, yes Greg's solution is working, thank you too for the sample you sent. Cheers Mario

[Greg_Deckler · Accepted solution]

@mariobeiutz I would recommend unpivoting your status columns in Power Query and then it should be straight-forward.

[mariobeiutz]

Dear Greg, thank you so much, so simple and it did the trick. Cheers Mario