Help with Chart set up

[Anonymous]

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 · Accepted solution]

Hi @Anonymous ,

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

[Anonymous]

That worked, thank you so much!

[Anonymous]

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]

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?

[Anonymous]

Hi

Can we try the following:

Add Completion as column

Add Program as a row

Add Completion as value: select count

Thank you

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

[Anonymous]

Resources:

This section is a video collection of our latest talks on Business Intelligence.

https://www.sqlbi.com/tv/

Dashboard in a Day: https://www.youtube.com/watch?v=hfyoPYEM4Ek

https://www.youtube.com/watch?v=AGrl-H87pRU

Thank you

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