Category: Visuals

Using Small Multiples in Microsoft Power BI

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.

Super cool feature Microsoft!

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.

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.

Underlying data in Microsoft Power BI Visuals

Some visuals provide the report consumer with the ability to “Drill Down” to the underlying data, i.e. the individual records or rows in the dataset in Microsoft Power BI.  In this video, I’ll show you this very feature in a Clustered Column Chart.

Continue reading Underlying data in Microsoft Power BI Visuals

Adding the Q&A Visual in Microsoft Power BI

In this Video, I’ll add a Q&A Visual to my Microsoft Power BI Desktop Report.  This visual uses Microsoft Bing “Natural Query Language” technology.  This is just a fancy way to say, you ask it a question, and you’ll get an answer back in the form of a visual.

Continue reading Adding the Q&A Visual in Microsoft Power BI