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
Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

August Community Highlights

Check out a full recap of the month!

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors