Matrix (visual) totals and subtotals in Microsoft Power BI

In this Tiny Tip, Belinda will uncover the secrets on getting only the (sub)totals that you want to see, using the Microsoft Power BI Matrix visual.

In this Tiny Tip, Belinda will uncover the secrets on getting only the (sub)totals that you want to see, using the Microsoft Power BI Matrix visual.

The most important thing to note is that the Grand Total is a Sub-total.  This means if you turn off the Sub-Totals, the grand totals disappear as well.

The Grand Totals will only always stay visible on the visual if you have the Stepped layout on; but if you turn the Stepped layout off, you can alter the labels for the totals.

Using an Inserted Shape as a Navigation option in Microsoft Power BI

In this Tiny Tip, Belinda will show you how to use a new feature to do something cool, using Microsoft Power BI: Page Navigation using an inserted shape.

In this Tiny Tip, Belinda will show you how to use a new feature to do something cool, using Microsoft Power BI.

In this report, there is a page that is Sales by category, with a slicer that displays countries.  There is a similar page, that displays a table with sales line details.  The slicer on the detail page is sync’d with the first page.

Belinda will Insert > Shape, selecting a triangle.  The April 2021 update has many more shape options.  Another great option for this example, opposed to the Triangle, would have been right arrow or the chevron.

Belinda will format the triangle and add an Action to the shape, on the Format shape pane.  The action assigned will be Page Navigation, then select the detailed page. 

Now, with a simple click in the web service (or a Ctrl+click in the desktop), users can easily navigate from one page to the next.

Copy Value/Table from Microsoft Power BI Report

Do you ever wish you could copy a value or a table in a Microsoft Power BI Report? Well, you can! Watch Belinda show you just how simple it is!

Do you ever wish you could copy a value or a table in a Microsoft Power BI Report?  Well, you can!  Watch Belinda show you just how simple it is!

Organizing Data with Folders in Microsoft Power BI

Sometimes a query in Microsoft Power BI will have so many fields that it is cumbersome. In this Tiny Tip, I will show you how to use folders to organize the query, making it easier to find the fields.

Sometimes a query in Microsoft Power BI will have so many fields that it is cumbersome.  In this Tiny Tip, I will show you how to use folders to organize the query, making it easier to find the fields.

Removing Duplicate Records in the Microsoft Power BI Query Editor

In this Tiny Tip, I will show you how to remove and check for duplicate records in the Microsoft Power BI Query Editor. In my example, I am pulling customer information from a Sales table. Hopefully, I am invoicing (or selling to) customers more than one time. Check out this tiny video on how I verify my data (aka repeat business).

In this Tiny Tip, I will show you how to remove and check for duplicate records in the Microsoft Power BI Query Editor.  In my example, I am pulling customer information from a Sales table.  Hopefully, I am invoicing (or selling to) customers more than one time.  Check out this tiny video on how I verify my data (aka repeat business).

Referencing a Query in the Microsoft Power BI Query Editor

In this Tiny Tip, I will show you how to break up a big flat query in the Microsoft Power BI Query Editor using Reference. This will prevent you from having to import the same data into your data model multiple times.

In this Tiny Tip, I will show you how to break up a big flat query in the Microsoft Power BI Query Editor using Reference.  This will prevent you from having to import the same data into your data model multiple times.

Creating a Template Page for Consistency in Microsoft Power BI

One of the first things I do when I start creating a Microsoft Power BI report is create a template page, which I call Blank. When creating a (new) page, I just duplicate the template/blank page and start building. This helps provide a consistent look for all my pages.

One of the first things I do when I start creating a Microsoft Power BI report is create a template page, which I call Blank.  When creating a (new) page, I just duplicate the template/blank page and start building.  This helps provide a consistent look for all my pages.

By Ms Belinda Allen

Importing data from a CSV Download into Microsoft Power BI

What if your Microsoft Power BI report needs to access data from a website, but the only option is a CSV download? In this tiny tip, Belinda will show you how to make a CSV download act like an API.

What if your Microsoft Power BI report needs to access data from a website, but the only option is a CSV download?  In this tiny tip, Belinda will show you how to make a CSV download act like an API.

More SEC Football data modeling in Microsoft Power BI Query Editor

In this tiny tip, I show you more Data Modeling I performed on my US College (American) Football South Eastern Conference (SEC) Microsoft Power BI Report. I show how I incorporate parameters with my data and I create a custom title for my report.

In this tiny tip, I show you more Data Modeling I performed on my US College (American) Football South Eastern Conference (SEC) Microsoft Power BI Report.  I show how I incorporate parameters with my data and I create a custom title for my report.

Creating a Custom Table in the Microsoft Power BI Query Editor

As I continue building a Microsoft Power BI report that will display the stats for the US College (American) Football South Eastern Conference (SEC); I will show you how I created a custom static table of the 14 teams in the SEC.

As I continue building a Microsoft Power BI report that will display the stats for the US College (American) Football South Eastern Conference (SEC);  I will show you how I created a custom static table of the 14 teams in the SEC.