Automatically filter report on actual date with calculated column and with measure

April 11, 2021
Denis Selimovic
Power BI Basicscomment 3Created with Sketch Beta.0 comments

Sooner or later, every Power BI developer will face the question of how to automatically filter a specific visual or the entire report to today’s date.This can be done in two ways: The approach with a calculated column is much more stable, since measures generally cannot or should not be used as filters. However, if…

Read more

Automation in Power BI – Format all measures, replace text, set default summarization and more

March 21, 2021
Denis Selimovic
Tabular Editorcomment 3Created with Sketch Beta.5 comments

One topic that I think doesn’t get enough attention is the ability to automate work in Power BI with the Tabular Editor. Especially the official documentation gives some nice insights into what the scripting engine can achieve.I would like to present a few examples in this article. Example 1: Automatic formatting of all measures If…

Read more

What is a Measure table and how can I create it properly

March 13, 2021
Denis Selimovic
Data modelcomment 3Created with Sketch Beta.0 comments

Although the feature has been in Power BI for a while, Measure Tables are not used enough in my opinion. Also during my trainings or in conversations with customers, I often notice that the feature has not really reached the minds of the report developers yet. What is a Measure Table and what does it…

Read more

Understanding Power BI Embedded with Source Code and Contoso Example Portal

February 6, 2021
Denis Selimovic
Power BI Embeddedcomment 3Created with Sketch Beta.1 comments

Power BI Embedded is a great way to integrate entire reports or specific elements from a Power BI reports into a company portal. Unfortunately, this is not always easy to explain and you need some imagination to grasp how this might look in practice. Power BI Embedded as a demo portal However, this has recently…

Read more

Calculate ISO 8601 week in Power Query

January 9, 2021
Denis Selimovic
Power Query / Mcomment 3Created with Sketch Beta.10 comments

Last week we already dealt with the topic of the correct calculation of the ISO week in DAX. Since the question came up about how to solve this in Power Query, I will look into it this week. For the problem with calendar weeks, I would like to refer to last week’s post. Calculation of…

Read more