Posts filed under Topics & Discussion

[DAX] Anti-Patterns Episode Five: Removing FILTERs (with Daniil Maslyuk)

A lot of videos and articles teach you how to write [DAX]. In this video Daniil Maslyuk and I will show you you how avoid bad [DAX] patterns! This episode will focus on ways to remove filters, understanding filter context and context transition!

GUEST BIO 👤

Daniil Maslyuk, MVP, is an independent consultant and the author of the official Microsoft Power BI exam reference books.

RELATED CONTENT 🔗

Daniil's Blog
Daniil's Twitter
Daniil's LinkedIn

Posted on March 15, 2022 and filed under Power BI, DAX, Topics & Discussion.

[DAX] Anti-Patterns Episode Four: FORMAT() Function (with Daniil Maslyuk)

A lot of videos and articles teach you how to write [DAX]. In this video Daniil Maslyuk and I will show you you how avoid bad [DAX] patterns! This episode will focus on Time Intelligence considerations and the FORMAT() function.

GUEST BIO 👤

Daniil Maslyuk, MVP, is an independent consultant and the author of the official Microsoft Power BI exam reference books.

RELATED CONTENT 🔗

Daniil's Blog
Daniil's Twitter
Daniil's LinkedIn

Posted on March 1, 2022 and filed under Power BI, DAX, Topics & Discussion.

(Livestream Replay) Effective use of Bookmarks and Buttons - with Ben Ferry (Power BI Guy)

Creating a report in Power BI should always include a stage of design that considers appropriate functionality for the end users. Though data transformation, modelling, and calculations are of course vital steps, failure to consider functionality can often, especially in the initial roll-out of Power BI within an organization, hinder user acceptance, or at the very least, overshadow the good work you have done preparing the data. The use of buttons and bookmarks can be a key element in your report preparation.

Bookmarks are a simple concept, but their value lies in their adaptability and often in the imagination of the report designer. This presentation aims to show how buttons and bookmarks can be leveraged to create sleek functionality, not only adding useful elements within your reports, but also giving you many other options as to how your data can be visualized. From absolutely essential buttons which should grace all reports, to niche bookmarks which serve as a sneaky workaround, the purpose of the presentation is to show how buttons and bookmarks, though sometimes tricky to set up, can make your life easier, but more importantly, help you create a report which does the data justice.

GUEST BIO 👤

Ben is Senior Data Analyst for online and highstreet opticians in Germany. Working with Power BI since 2017, he is one of the lucky few who can count his job as his hobby. Ben’s main pleasures in Power BI come from exploring and defeating APIs with Power Query, finding new tricks to achieve interesting reports and spreading the good word of Power BI.

RELATED CONTENT 🔗

Power BI Guy: YouTube
Power BI Guy: Twitter

(Livestream Replay) Uncovering Secrets and Mysteries in your Power BI Tenant - with Benni De Jagere

Microsoft Power BI is all the rage, with enterprise and user adoption soaring year after year. New users get onboarded, reports, models, dashboards, dataflows, …get created and tweaked every day. Whoa, things must be going great if we have so many things happening every day! Right?

And yet, as the usage skyrockets in our organization, it's crucial to keep a solid oversight of the artifacts and activities generated by our colleagues. All too often, organizations have procedures, governance models, methodologies, and more in place, without having a structural way of making sure it actually works for the business processes. Enabling the business to make their decision on usage information for their artifacts will assist them in making informed decisions. Making sure this information gets to Data Stewards (workspace owners) is often left untouched, as there's no ready to go solution out there.

This chat will focus on a Self-Service Power BI model and report, where users can follow up on activities performed on artifacts in their zone of control.

GUEST BIO 👤

Benni De Jagere is a Program Manager in the Power BI Customer Advisory Team at Microsoft. On a daily basis he turns (large amounts) of coffee into insights for customers, and references witty British comedy, lame dad jokes, and obscure facts way too often. Overly enthusiastic about anything data related, he’s trying hard to keep up with all things new and shiny. Loving (almost) every day of it, he’s fascinated by the value of data, sometimes flabbergasted by the lack of awareness, and intrigued by the endless possibilities whilst discovering new ways of looking at data. He thrives on unfolding new insights for customers whilst using an open and transparent communication.

RELATED CONTENT 🔗

Benni's LinkedIn
Benni's Twitter
Benni's Blog
Benni's GitHub