Recently I was asked how to only show the data for the last date in a Microsoft Power BI dataset. I immediately said “DAX”, but ended up with some complexity that was not necessary. After some rounds with DAX and M, my “aha” moment occurred. Actually, it was more my “inner data modeler” saying “Belinda…. Get With It!”
Filters… Filters is all that is needed. Watch this video and see how easy it is
Microsoft Power BI has a cool feature in Preview, that allows you to split a single visual into multiple visuals based on a filter. In this video, I take Sales by Customer Class (Group/Category), create small multiples based on the class, and make the axis a class for Items sold. This feature works on several of the “out of the box” visuals. In the attached video, I will use a clustered column chart and a line and clustered column chart.
I love using this feature when the visual (using the small multiples) is the only visual on the page, taking the entire page.
I will also show you some formatting options for small multiples as well.
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.
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 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.
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.