Building on the steps shared in my blog posts, How to Install Power BI Desktop, Getting Started with Power BI Desktop and SCCM, and Adding a Calculated Column to a Power BI Table, in this post I will be adding a chart to a Power BI dashboard. It might be helpful for you to review the previous blog posts to see how we got to this point.
Again, as a reminder, this is what our Power BI canvas looks like now.
Adding a Chart to a Power BI Dashboard
Drag the Age column to an empty area on the Power BI canvas. Notice how Power BI automatically selects a bar chart for you. Congratulations! You now have a chart on your dashboard. Wasn’t adding a chart easy? Okay, I hear you, as it stands it isn’t that useful, but wait for it!
In real-time the chart changes as you drag each item to the VISUALIZATIONS section! In order to make this chart easier to read, I modified it by re-sizing it. Look for the steps on how to do this later on in this post.
How to Change a Chart Style
Again in real-time, as I select the chart style, I see it updated to the donut style. This is great because I can try out different chart styles quickly and easily.
How to Change the Title of a Chart
Update the text in the Title Text area. In my case, I changed the title to Count of Computers by Age.
This is what my chart looks like now. I like it!
How to Turn on the Chart Legend
Clicking on the down arrow reveals that there are extra values. Isn’t that neat?
How to Resize a Chart
When you select the chart on the canvas you’ll see that there are items that you can point to, click on and drag. Using these features will change the size of your chart by making it either larger or smaller.
Why It’s Important to Get Your Query Right
What happened? If you remember, back in the Getting Started with Power BI Desktop and SCCM post, I showed you a screenshot of my query. By accident I joined dbo.v_FullCollectionMembership and dbo.v_Collection together. I also did not include a Where statement to only show computers from a particular collection. What this means is that the number 76 is the combined total of the computers with ages equaling “4” within all collections.
How do you fix it? As I explained in one of my previous posts, there are two ways to fix this problem. First you could fix the original query, or the second method involves adding a filter to the chart. Below I will show you how to add a filter to the chart.
At last the 4-year-old donut wedge shows a count of 4 computers and not 76!
This is one of the reasons why it is always important to test your queries in order to ensure that they are correct. If you aren’t getting the expected results, then you need to troubleshoot in order to figure out what’s wrong.
Do you feel like you’re done after adding a chart to your Power BI dashboard? If you’re like me you’ll know that there is so much more that you could do, but those changes will be topics for future blog posts!
Stay tuned because my next blog post will be all about color! Specifically I’ll show you how to apply color to items within charts and then I’ll compare my Power BI chart to a similar chart that I created with SQL Server Reporting Services (SSRS).
What else would you like me to post about for Power BI Desktop? If you have any suggestions, please feel free to contact me @GarthMJ.