Power BI Custom Format String Examples, Part 1: Numbers

Now that we can apply custom format strings to fields and measures in Power BI in the September 2019 release, I thought it would be useful to provide some examples of what’s possible with this very flexible new feature because the existing documentation for VBA isn’t easy to make sense of. In fact there’s so much to say I’m going to have to write a series of blog posts to cover everything! In this first post I’m going to look at formatting numbers.

Source : Chris Webb’s BI Blog
Read more…

Adding More Aggregate Columns To The Output Of Table.Profile

A few years ago I blogged about the Table.Profile M function and how you could use it to create a table of descriptive statistics for your data:

https://blog.crossjoin.co.uk/2016/01/12/descriptive-statistics-in-power-bim-with-table-profile/

Since that post was written a new, optional second parameter has been added to the function called additionalAggregates which allows you to add your own custom columns containing aggregate values to the output of Table.Profile, so I thought I’d write a follow-up on how to use it.

Source : Chris Webb’s BI Blog
Read more…

5 Reasons We Love Microsoft Power BI

With data clearly taking the position as king in today’s business world, it’s important to have a tool that can help you tame it and use it to your advantage. Microsoft is all about helping you create a “data culture” in your organization—in other words, taking advantage of data across the organization to tackle any problem and meet any goal. Microsoft Power BI does just that…but what about other tools? Yes, there are other options, but there are so many benefits offered by Power BI that we believe it’s clearly the best choice. Here are 5 reasons why we love Power BI:

Source : ArcherPoint
Read more…

Why Power BI Slicers Sometimes Show Values That Do Not Exist

The problem of blank values being shown in a Power BI slicer is fairly well known, but did you know that in some circumstances slicers can show other values that you would not expect to see? While there’s a good reason for this it can nevertheless be mildly confusing for developers and end users alike when it happens.

Source : Chris Webb’s BI Blog
Read more…

Power BI Deployment Reports Tips for Business Central Users

In addition to integrating Power BI into Business Central, it could be useful to be able to use a fast access portal or receive scheduled reports from Power BI automatically without going through the complete Power BI (Pro and Premium) solution. All this is already existing and usable if I use Power BI Premium license or Pro license, or if I integrate MS-Flow, MS-Sharepoint Online etc. etc

Source : Roberto Stefanetti NAV & Business Central Blog
Read more…