cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Top 10 from Yes/No choice column - SharePoint List

I have a sharepoint list with more than 50 yes/no choice columns, and with more than 15,000 items. My end goal is to create a Power BI report to display top 10 columns with count of "Yes" values. Please guide me step by step.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Top 10 from Yes/No choice column - SharePoint List

Hi @bhashwar,

 

You can refer to below sample file to know how to count column items and get specific columns.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Top 10 from Yes/No choice column - SharePoint List

Hi @bhashwar,

 

You can refer to below sample file to know how to count column items and get specific columns.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Highlighted
New Member

Re: Top 10 from Yes/No choice column - SharePoint List

Thank you @v-shex-msft,

For some reason, after i group the Attribute columnto sum the custom column, it does not sum all the values when i directly connect from the sharepoint onprem list data source as a web source.

It worked perfectly when i exported the list to excel file and then took that as the data source. I will have to refresh the excel file everytime now, and then refresh the power bi file to get the current data since we do not have the gateway or SQL enterprise.

Thank you anyways!

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors