Microsoft Dynamics Business Central as a Data Type in Excel via Power BI

While hosting yesterday’s Power Platform Mix it up with New View Strategies, Microsoft Senior Program Manager Blazej Kotelko talked about using Microsoft Dynamics Business Central Data, specifically a dataset in Microsoft Power BI as a source for Data Types in Excel.  Several of us hung out yesterday and tried to do it.  We thought we missed something because it wasn’t working.  Today though, I noticed it appeared and it works!  My mind is blown!!!!  Watch the end results.

The “How this is done” video will come soon.  Thanks to the friends that hung out with me and worked on this:

Shawn Sissenwein

Krzysztof Bialowas

Jeremy Vyska

Gert Hector

Power Platform Mix It Up is a community meetup focused on all things Microsoft Power Platform using Microsoft Dynamics 365 Business Central.

Show Value for the Last Date in Microsoft Power BI

Another Tiny Tip!

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

If this helped, how about buying me a coffee?

More Matrix (visual) formatting in Microsoft Power BI

The Microsoft Power BI Matrix visual has more features waiting to be unlocked with formatting.  In this Tiny tip, I will show you some of my preferred formatting options.  Specifically, I will show:

  • Changing the Text size
  • Changing the alignment of a column
  • Conditional formatting for a column of values
  • Changing the values to display as rows rather than columns.

The last feature can be a real space saver when you have a lot of data, and it can allow you to have a larger font for easier reading without the need to scroll.

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.

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.

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.