Brunner_BI
Allocating amounts using lists in Power Query
We will show you how to create dates between a start and an end date using the list operator in Power Query. This can be handy as well for a
Suche
Brunner_BI
- 18. Dez 2021
- 2 Min.
Extending calculation groups in Power BI with unstructured data (targets, budgets etc.)
Calculation groups in Power BI a lot of times rely on time intelligence calculations. If you do not know calculation groups yet, read...
2 Ansichten0 Kommentare
Brunner_BI
- 14. Dez 2021
- 1 Min.
Dataflows gets around the 3,000 cell enter data limit in Power BI
This blog posts shows that in Power BI Dataflows you can get around the 3,000 cell paste limit (Enter Data) in Power BI Desktop
8 Ansichten0 Kommentare
martin1119
- 30. Sept 2021
- 2 Min.
Time saving scripts in Tabular Editor
How to format all dax measures in one click. How to add descriptions to your measures using Tabular Editor. Good for live reports especially
17 Ansichten0 Kommentare
Brunner_BI
- 4. Sept 2021
- 7 Min.
How I use Azure VMs for Power BI development
For once this is not a technical blog about a feature or trick in Microsoft Power BI. In this blog post, I want to explain the benefits...
24 Ansichten0 Kommentare
Brunner_BI
- 10. Juli 2021
- 3 Min.
How to visualize any map in Power BI
Until a few months ago, I have only worked with either Bing maps, filled maps or shape maps (these are the standard visuals in Power BI)....
488 Ansichten0 Kommentare
Brunner_BI
- 3. Juli 2021
- 3 Min.
Dynamic pop-up or warning images in Power BI
For me, Power BI has become a rather complete tool over the last few years. Some things are still missing though, like pop-up messages....
49 Ansichten0 Kommentare
Brunner_BI
- 5. Juni 2021
- 1 Min.
Dynamic tooltip pages in Microsoft Power BI for measures as columns
This post explains how you can make your tooltip pages in MS Power BI completely dynamic to show different measures.
167 Ansichten0 Kommentare
Brunner_BI
- 24. Apr 2021
- 1 Min.
Trigger instant refreshs of Power BI Datasets with Power Automate
Automatically trigger a refresh for a Power BI Dataset when a Dataflow refresh completes. This can be achieved easily using PowerApps.
305 Ansichten0 Kommentare
Brunner_BI
- 27. März 2021
- 3 Min.
Fixing Delta % once and for all
How do you correctly calculate a Delta % YTD or just a percentage change of two values? Check out my Power BI Blog post for a DAX solution
59 Ansichten0 Kommentare
Brunner_BI
- 10. Jan 2021
- 1 Min.
How to fix duration data types in Power BI Dataflows
Power BI Dataflows are still pretty new to most. I think it is amazing that Power Query has moved to the cloud and you can use it with a...
42 Ansichten0 Kommentare
Brunner_BI
- 9. Jan 2021
- 1 Min.
How to force users to select a filter in Power BI while keeping the report interactive
One of our clients recently asked us to find a better solution for forcing users to select a filter value. They had this: The first...
53 Ansichten0 Kommentare
Brunner_BI
- 29. Dez 2020
- 1 Min.
How to avoid having to use a personal gateway for web data sources (html page or table) in Power BI
When you import publicly available data into your report you will most likely use the web connector in Power Query. This might lead to...
1,114 Ansichten8 Kommentare
Brunner_BI
- 17. Dez 2020
- 1 Min.
Changing data types that do not break query-folding in Power Query / Power BI
There are some data type changes that can be performed without breaking query-folding. We tested this with SQL Server 2016 as a data source
861 Ansichten0 Kommentare
Brunner_BI
- 15. Dez 2020
- 1 Min.
Creating a custom fiscal calendar in Power BI
Transforming your custom fiscal dates to number format and then generating a list of values between them will give us all dates in between.
174 Ansichten0 Kommentare