If you want to become an Power BI expert, check out all our helpful tutorials on Microsoft Power BI. All the tutorials are written by experts and followed steps properly and written with screenshots. You can email us if you still have questions for us.
I built a client a sales matrix with products in the rows and months across the top. The numbers were right, but the months read Apr, Aug, Dec, Feb. The client’s first question was how to sort columns in the Power BI matrix so January came first, and the second was how to show the … Read more >>>
In my previous tutorial, we saw how to work with table visuals in Power BI. In this tutorial, I will show you how to format a table in Power BI with various examples, including conditional formatting. You will learn here about the following formatting options. Apply Formatting to a Power BI Table visual Let’s explore … Read more >>>
Power BI doesn’t have a “default value” box for slicers. That surprises almost everyone, because the first thing a report owner asks for is “open the report on this month” or “always start on the West region”. There are reliable ways to get the same result, though. In this tutorial, I’ll show you six of … Read more >>>
On one of my first Power BI projects, the report page had six slicers stacked down the left side, each one a long list of checkboxes. Users had to scroll just to find the chart they were filtering. Switching those slicers to dropdowns freed up half the page and made the report far easier to … Read more >>>
Recently, I have designed a Power BI report with different visualizations. To filter the values on the report, I added a Slicer visual to it. If the Slicer consists of too many items, such as Project Names or Product names, etc., this helps to filter the values. It will take time to find the specific … Read more >>>
Learn how to edit visual interactions in Power BI. Set Filter, Highlight, or None, change the default to cross-filter, and fix common issues. Free Excel file.
Merge vs Append in Power BI explained: learn the key differences, all 6 join kinds, fuzzy matching, and exactly when to use each, with step-by-step examples.
When I build reports for clients, the data almost never comes in one clean table. Sales sit in one file, product details in another, and region information lives in a SharePoint list. To report on all of it together, I need to merge tables in Power BI. In this tutorial, I’ll show you exactly how … Read more >>>
A client asked me for a report where managers could just type a question, like “total sales by category”, and get a chart back without learning Power BI. The Q&A visual does exactly that: you ask in plain English, and Power BI picks the fields and the chart for you. In this tutorial, I’ll show … Read more >>>
A colleague of mine built a sales matrix in Power BI with products on the rows and years across the columns. Two cells were empty, and his manager’s first question was whether the data was missing. It wasn’t: those products simply sold nothing that year, and a 0 would have said so much more clearly. … Read more >>>
122 copy-paste formulas with real examples, sent straight to your inbox.
Your free Power Automate Expressions Cheat Sheet is on its way. Can't find it in a few minutes? Look in your Promotions or Spam folder.
Sent to