Solved: Re: Help with Chart set up

Anonymous · ‎11-19-2019

Hey folks,

If you want to skip the context, my question is lower down in bold.

First and foremost, I have 0 experience with Power BI, database management, or report creation (outside of Excel). I've been tasked to take a large dataset (large here meaning an Excel file export of about 100,000 rows x 25 columns) and create a report out of it.

Power BI was recommended, and so far it's been pretty easy to use for importing data. But I'm on the part to create reports and I'm just lost and overwhelmed by the large amount of very lengthy, detailed resources available online.

Simply put, my question is this: How can I create a chart that shows Course Completions by Program, where Course Completions are the statuses of learners for a particular course, and Program is the high level title of where each course "lives"?

I've linked a screenshot to show what I mean.

(Currently the chart is just counting the total number of completions per program and not specifying the completion type, i.e. complete, in progress, not started, etc.)

Also, does anyone know of a good resource for people new to this kind of work? i.e. Power BI for dummies? I need to learn how to use this program but there's just so much information out there that I'm not sure where to start and what resources are aimed at new dummies like me...

Any and all help would be GREATLY appreciated! 🙂

v-eachen-msft · ‎11-20-2019

Hi @Anonymous ,

According to your discription, you need to add legend in the visual like the following image.

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

View solution in original post

v-eachen-msft · ‎11-20-2019

Hi @Anonymous ,

According to your discription, you need to add legend in the visual like the following image.

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

Anonymous · ‎11-20-2019

That worked, thank you so much!

Anonymous · ‎11-19-2019

Hi

Did you try to use a table? Also, do you have the marked for course completion status, if so you can just drop it on the table.

Thank you

Tomas Santandreu Polanco |Principal Business Intelligence Consultant
www.designmind.com

Anonymous · ‎11-19-2019

Hey there,

I have a table set up (I think) with all the fields I intend to use and/or manipulate. Here's the screenshot: https://i.imgur.com/mshLX6c.png

For the Completions by Program, it keeps defaulting to doing a Count of Completions which is what's giving it the number of completions regardless of the value in that column (i.e. if there are 6 "Completed" records and 4 "In Progress" records, it shows a value of 10 Completions rather than 6 Completed, 4 In Progress).

I want it to instead show a bar chart that would show 6 Completed, 4 In Progress for a total of 10 rather than JUST the total, if that makes sense.

I tried looking up a tutorial on how to do this but nothing I found explained things simply enough. The videos you linked look like they may work, but that goes back into my previous statement about all the resources being TOO long/lengthy. The video you linked has so much context and other pieces that it's more confusing than helpful...

I'm going to be learning over time, and will definitely use the video you provided and the 3,000 page PBI Get Started PDF for help, but in this instance it's extremely frustrating to be stuck not being able to do something so simple without combing through literally hours of videos or hundreds of pages of text, y'know?