It’s Hot Tip time here on How To Use Power BI, and for this tip, we’re going to learn about Display Folders, a little hidden feature in the Model View of Power BI Desktop. They are going to be your new best friend if you have to build reports with…
One of Power BI’s great strengths is that we can easily create visuals and entire dashboards using data from multiple data sources. As long as the data has something in common (ideally a unique identifier – we’ll talk about that in a minute), we can link data sources together and make…
In this post we’re going to learn how to format Pie Charts.I highly recommend that before learning from this post you watch/read the post about how to make a Pie Chart, which goes over how NOT to make them as well. Pie Charts are your best chart option in very…
Let’s learn how to make everyone’s fave chart in Power BI, the Pie Chart!Just kidding, Pie Charts don’t get a ton of love in the data visualization world, and there are lots of situations when they should NOT be used, but there are also times when they SHOULD be used.So,…
Let’s learn about Slicers! Slicers are a LOT like Filters, but live right ON your Power BI report’s canvas so your report viewers can interact directly with them and decide how to slice and dice the data in the other visuals. For this post (and the video below) we’re going…
We’re going to learn a bit more about our Formatting options in Power BI Desktop in this post. Power BI has some page formatting options that are good to know about if you need them. Post Subjects: User Interface | Formatting The Page Formatting tools show up when…
Today we’re exploring how to merge columns Power Query Editor. Sometimes you get stuck with data where two columns have data that SHOULD be in one column. We’re going to learn how to easily bring them together. Post Subjects: Power Query This post (and video below) uses a new blank…
Today we’re exploring how to split a column in Power Query Editor. Sometimes you get stuck with two data points in one column and you need to split them out into different columns so you can visualize each, or use one of them in a slicer or a filter.This post…
We’re exploring a really common function that comes with Power Query editor today, and that’s how to promote column headers in your data if Power BI can’t figure out what your headers are.This post (and video below) uses a new blank Power BI report and connects some simple data to…
This post is about how to implement basic formatting in a Line Chart in Power BI. When I say “basic” formatting, I mean what you should do EVERY time you build a Line Chart to make it as easy for your users to understand. For this post (and video) we’re…
