This post is also available in:
Deutsch
Measures are the best way to calculate your key figures in Power BI. In a matrix, however, these can normally only be displayed as values and not at row or column level. However, sometimes you need them exactly at the row level.
Display contribution margin calculation at row level
An example I came across recently was the presentation of a contribution margin calculation. I already apologize if the English terms are not translated correctly, my original calculation was in German ? . The individual items should be displayed below each other at row level. The default view, when displaying only the Measures, is horizontally aligned:
This post is also available in:
Deutsch
I recently received a tip from a colleague at work, which was also something I hadn’t seen before. More precisely, it was about integrating a Power BI report with all reporting options into a OneNote page.
For this purpose, I use the report with the manual fonts as an example. The report has to be shared on Power BI Services (powerbi.com) via Share –> Embed report –> Publish to web (public):
Warning: When sharing via “Publish to
This post is also available in:
Deutsch
If you find a date or datetime format in UNIX format, the first thing you wonder is what it is all about or how you can display it “normally”. This is because the UNIX date format looks like this:
1604135115
What exactly is UNIX Timestamp?
To find a way to convert this, we first need to understand what the number means. The UNIX timestamp is the number of seconds since January 01, 1970. You can read exactly about why it is like this in the Wikipedia article. I want to focus on finding a
This post is also available in:
Deutsch
For a while, it was only possible to provide a Power BI report in multiple languages using workarounds. Recently, the enhanced dataset metadata has made it very easy to change the language of a report in Power BI, making it multilingual, for example in German and English. Since the Power BI September Update, the enhanced dataset metadata is now the standard for metadata, upgrading a Power BI report almost to the level of an SSAS Tabular Model.
Enhanced dataset metadata enables SSAS Tabular functionalities
One of these new capabilities is to offer the data model of each Power BI report in multiple languages.
The easiest way to maintain multiple languages is currently using
This post is also available in:
Deutsch
Many companies are trying to achieve a consistent appearance and have corresponding or Corporate Identity / Corporate Design (CI/CD) guidelines.
As a reporting platform, Power BI should of course be no exception and fit into the corresponding specifications. However, this is often a big question mark, because at first glance there is no option to add additional fonts in Power BI. There is only a selection of standard fonts to choose from:
This post is also available in:
Deutsch
When you often work in different IT environments, you can easily reach the point where a customer is working with a different Power BI desktop version than the latest one. As a developer this can become a problem, because the PBIX files are generally not backward compatible to older Power BI versions. As a result, the completed work may not even be accessible to the customer.
Why the download from the Power BI Blog does not work
In the past I used to google for the wanted release article in the Power BI Blog and then download the file there. Unfortunately, this approach no longer works, as the links now all point to the latest release. This may be good for end users, but as soon
This post is also available in:
Deutsch
If you want to combine several tables, you have to ask yourself whether you should do this already in the data source such as SQL Server, in the processing of the data (ETL) in Power Query or in Power BI and, above all, where exactly there is a difference.
First of all, the post is relatively detailed, for all of those who consider it too long (tl;dr) here is the comparison table:
| Duplicate entries remain | Duplicate entries are removed | Unequal number of columns | Deviating column names | Different order of the columns | Combine more than 2 tables | |
|---|---|---|---|---|---|---|
| UNION in SQL Server | With UNION ALL | With UNION | – | x | – | x |
| APPEND in Power Query | x | Possible with “Remove duplicates” | x | – | x | x |
| UNION in DAX | x | Possible with “DISTINCT” | – | x | – | x |
Data transformation in the data source or in the frontend?
A question that
This post is also available in:
Deutsch
What at first sounds complicated and not very useful, can be found in reality from time to time. Recently the automated export of source data from another program in CSV format confronted me with this task.
Daily folder for automated export
Unfortunately, when exporting from the source system – apart from the target directory – very little could be adjusted. The result is that the automated export job daily creates a new folder with the current date, similar to the following example:
In this example it is only necessary to load the files from the newest folder, because this folder contains the entire data. However, the file names also change with
This post is also available in:
Deutsch
In yesterday’s poston the Power BI Blog, Microsoft announced the upcoming Power BI Premium for individual users.
The advantages of Power BI Premium compared to a normal Pro Account are quite clear: 48 refreshes per data set per day compared to 8 refreshes with the Pro License, automated machine learning possibilities, cognitive services, the up to 16 times better performance (according to Microsoft) and the significantly higher limit for the size of data sets offer among others a huge added value.
Premium up to now only affordable for large companies
The problem so far is that Power BI Premium starts at 4’995 USD – noted per month. This corresponds to the financial expense of about
This post is also available in:
Deutsch
In times of Corona we have to take other ways to avoid the gathering of larger crowds.
Such as Microsoft, which is setting this year’s Ignite from 22-24.09.2020 as an exclusively virtual event. For Europeans maybe not even the worst decision 😉
You can register on the Ignite website:
https://myignite.microsoft.com
According to the PBI blog the following sessions are about Power BI:
Live Sessions
Microsoft Power Platform: Fill the app gap and supercharge organizational agility
Live Tuesday Sept 22: 9:30 – 9:50 AM PDT
Replay Sept 22: 5:30 – 5:50 PM PDT
Replay Sept 23: 1:30 – 1:50 AM PDTDeliver insights where decisions are made with Power BI
Live Tuesday Sept 22: 12:15 – 12:45 PM PDT
Replay Sept 22: 8:15 – 8:45