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

Data from sharepoint list dropdown menu showing as [list]

I have a sharepoint list that we use for logging incidients.

 

It has several fields, including incident name, category, outcome, date, description and created by.

 

Category and Outcome are both dropdown menus that have about 20 options of each. They are not multiple choice, each list needs to pick one.

 

I am trying to make a graph that shows Category by Outcome, so that someone can click on a category, for example "Physical Violence" and see how many different outcomes come under this category, for example "Exclusion" or "Detention". This is so we can try to make sure our response to incidents is consistent. 

 

However both of these fields are pulled into Power BI Desktop as [list] and do not show what has been selected in the list. I can understand this if it was possible to have multiple entries, but that's not possible.

 

Any idea how I can move forward?

 

Thanks in advance!

James

1 REPLY 1
Highlighted
Resolver III
Resolver III

Re: Data from sharepoint list dropdown menu showing as [list]

@JamesBray

 

Hi,

 

could you give a glance here?

I think it could help you.

 

Regards

 

 

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

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

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors