Forum Discussion
Power BI count unique values in a column from SharePoint list
something like this?
Hi lbendlin ,
| FTT NAME | PTT NAME | PTT GRADE | DATE | COLLABORATION | Proactively supports co-trainer(s) | Follows lead trainer guidance /decisions | Communicates with lead trainer in a timely manner | KNOWLEDGE | Delivers correct SEP knowledge | Able to provide additional knowledge (apart from the OME) | Answers questions confidently and knowledgeably | DELIVERY | Able to objectively evaluate leaner(s) performance | Able to respectfully deliver objective /constructive feedback to learners during the practical sessions | Respectfully deliver theory sessions | Communicates with learners appropriately | Adheres to approved timetable /training material(s) | Manages all training resources efficiently |
| Hussein | Ahmed | PUR | 07/12/2023 00:00:00 | C | C | C | C | C | C | C | C | C | C | C | C | |||
| Hussein | El Ias | GR1 | 06/12/2023 00:00:00 | CWF | CWF | CWF | C | C | C | C | C | C | C | C | C | |||
| Hussein | Wissam | CSV | 08/12/2023 00:00:00 | C | C | C | C | C | C | C | C | C | C | C | C | |||
| Tilina | Yvonne | PUR | 08/12/2023 00:00:00 | C | C | C | C | C | C | C | C | C | C | C | C | |||
| Tufan | Roxanne | PUR | 08/12/2023 00:00:00 | C | C | CWF | C | C | C | CWF | C | C | C | C | C | |||
| Trevor | Saba | CSV | 08/12/2023 00:00:00 | C | C | C | CWF | CWF | CWF | C | C | C | C | C | C | |||
| Xiyao | Sean | PUR | 01/12/2023 00:00:00 | C | C | C | C | C | C | C | C | C | C | C | C | |||
| Wael | Francesca | GR1 | 07/12/2023 00:00:00 | DEV | C | C | C | C | C | C | C | C | C | C | C | |||
| Mary | Mijat | PUR | 08/12/2023 00:00:00 | C | C | C | C | C | C | C | C | C | C | C | C | |||
| Hussein | Michael | PUR | 08/12/2023 00:00:00 | C | C | C | C | C | C | C | C | C | C | C | C | |||
| Hussein | Janka | CSV | 08/12/2023 00:00:00 | C | C | C | C | C | C | C | C | C | C | C | C | |||
| Hussein | Deon | PUR | 08/12/2023 00:00:00 | C | C | C | C | C | C | C | C | C | C | C | C | |||
| Hussein | Manpreet | PUR | 08/12/2023 00:00:00 | C | C | C | C | C | C | C | C | C | C | C | C | |||
| Orsolya | Maleena | GR1 | 08/12/2023 00:00:00 | C | C | C | C | CWF | C | C | C | C | C | C | C | |||
| Christian | Ahmed | PUR | 27/12/2023 00:00:00 | C | C | C | DEV | CWF | C | C | C | C | C | C | C | |||
| Hussein | Alexandra | CSV | 27/12/2023 00:00:00 | C | C | C | C | C | C | C | CWF | C | C | CWF | C | |||
| Hussein | Shauna | FG1 | 03/01/2024 00:00:00 | C | C | C | C | CWF | DEV | C | C | C | C | C | CWF | |||
| Hussein | Lejla | FG1 | 10/01/2024 00:00:00 | C | C | C | CWF | CWF | C | DEV | C | C | C | C | C | |||
| Hussein | Anna | GR1 | 11/01/2024 00:00:00 | C | C | C | C | C | C | C | C | C | C | CWF | C |
This is the table before unpivoting as I couldn't upload it due to the duplicates. Please unpivot the columns and see the duplicates.
Desired outcome:
something like this?
Yes!!
So how can I do it on my dashboard? as the table I have has more columns.
How can I share with you my pbix file?
The process is the same, regardless of how many columns you have.
If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Here is the link to the file.Thank you and Happy new year 🙂
Instead of unpivoting the individual sections separately you need to unpivot all at once.
Can you provide a sanitized extract of your SharePoint list?
Hi lbendlin ,
I tried unpivoting all at once but how do I select which ones go in each visual?
Here is the link to sharepoint list : https://we.tl/t-I097XfqURB
No, I have to check how to hande list templates, a first for me.
Appreciate your help 🙂