This post is also available in: Deutsch I like working pretty much with the what-if parameter in Power BI. With the help of this, it is possible to run through corresponding scenarios in a very fine-grained manner. What would my operating result look like if I can increase my sales by a factor of 2? How would it look with 1.5? And how about 2.35? I am aware that these increases are extremes. But with the what-if parameter, such evaluations go very easily with a single slider. Problem the what-if parameter does not work, the exact number cannot be set However, there is occasionally the case that exact values cannot be set. Let’s take the case just mentioned as an example. I would like to evaluate the development of my sales, accurate to 0.01 points. Accordingly, I create a what-if parameter: As range I would like to be able to select from -20 to 20 and the individual values should increase by 0.01 points: Now when I try to adjust the slicer of the what-if parameter to 1, 1.5 or 2.35 something strange happens, I don’t get the slicer set exactly to the value I want: Reason: Limitation to […]
This post is also available in: Deutsch Occasionally, as a Power BI developer, you are faced with the task of replacing the data source in existing reports with a published Power BI dataset. Especially if there are already several reports that were created with a copy of a PBIX file and are now to be consolidated to the same dataset. The question here is how best to proceed in order to achieve the goal as efficiently as possible. Delete the old data I had tried many approaches in the past, but the simplest one is by far the most efficient. I would like to demonstrate this using the example of my vaccination statistics, where I access the dataset of the German report for the English version. Still I would like to take the visualization as a basis from the original report. In the first step we need to delete the existing data. This sounds brutal at first, but trust me, the individual visuals will work again later when all tables, columns and measures are named identically. 1) So in the first step, we delete all the tables created by DAX, including the Measure table, directly in Power BI: 2) […]
This post is also available in: Deutsch In Power BI, I repeatedly encounter the situation that it does not work to export the underlying data. The option is simply not available. In general, this can have several reasons. In the following article we will take a look at the possible reasons for this. 1. Disabling in Power BI report The author of a report can limit the export for the specific report. For this purpose, it is possible to select in the options in Power BI Desktop whether users are allowed to export summarized data, the underlying data or no data at all: 2. At least build permission in Power BI Services Most of the time the error is due to the missing permissions. In order to export the data, the user needs at least the build permission for the corresponding data set. As soon as the user has more permissions for the data set, for example administrator permissions, it does not matter anymore. But as a normal user with read permissions, the build permission must be set additionally. How exactly this is done is explained in the documentation:https://docs.microsoft.com/power-bi/connect-data/service-datasets-build-permissions 3. Sensitivity label for data set If the first two […]
This post is also available in: Deutsch A few weeks ago, I visualised the current status of vaccinations in the canton of Basel-Stadt with Power BI in a weekend project. I have received a lot of positive feedback in response to this. Many thanks at this point for that. In addition, there were numerous requests to extend the report to cover the whole of Switzerland. It took a few days, but the report now contains data for the entire country. The Power BI Report can still be accessed at: https://impfstand.ch The selection of the canton can easily be done using the navigation: New features that are now included are: Consideration of the individual cantons or of Switzerland as a whole. Current vaccination statistics can be filtered to the population aged 20 and above. This was implemented because the vaccinations are only permitted from the age of 16 and 18 years. Unfortunately, population figures are only available from 20 years of age and up. First and second vaccination by day of the week. Comparison of first and second vaccination between all cantons. In the next few weeks there will be some changes, including an English version. Therefore, you are welcome […]
This post is also available in: Deutsch This past weekend, I had an aha moment. My girlfriend asked me what the current status of COVID-19 vaccination was here in Switzerland in our area, which means in the canton of Basel-Stadt. After a short internet research, we found either newspaper articles that were already a few weeks old or statistics that presented the current figures only insufficiently or in a complex way. The canton of Basel-Stadt provides all data as CSV and JSON on its Open Data Basel-Stadt website and allows the use under the Creative Commons license. Current vaccination status as Power BI Report for Basel-Stadt As a Power BI enthusiast, I immediately thought of presenting the whole thing in an easy-to-understand Power BI report. No sooner said than done, I prepared the data in Power BI, hopefully presented it in an easy to understand way, and created a website for it. May I introduce: https://impfstand.ch […]
Deutsch
