www.powp.co

“The illiterate of the future are not those who can’t read or write but those who cannot learn, unlearn, and relearn” — Alvin Toffler

Have you ever walked a “known” road, and all of a sudden, you noticed something extraordinary you didn’t see before? Well, that is what re-learning means for me: walking a known path and noticing things that probably were there before, but you didn’t see, or new things that were not there on your last walk.

Today I will start my DAX re-learning journey, and I’ve chosen SQLBI as my guide through it simply because these guys ROCK! I consider there is a consensus among the Microsoft Business Intelligence community that Alberto and Marco are truly THE DAX guys.

“Incredible analytical…


“It was the possibility of darkness that made the day seem so bright.” — Stephen King

You can get the files of this story (and other useful resources) by subscribing to the PowPCo Newsletter. https://www.powp.co/powpco-signup-newsletter-form/

For a couple of years, we’ve seen a boom in applications supporting dark versions of their interfaces, and there are at least two good reasons for having a Light and Dark version of your Power BI reports:

  • Accessibility: dark versions of reports can facilitate reports consumption by users with some types of visual impairment.
  • Users preference: some users prefer light-themed reports, others dark.

The way I see it, in Power BI, there are two main approaches for creating these two versions…


“People ignore design that ignores people.” — Frank Chimero

You can get the files of this story (and other useful resources) by subscribing to the PowPCo Newsletter. https://www.powp.co/powpco-signup-newsletter-form/

If you are not spending enough time on the user experience, you could be flushing down the toilet all of the hard work done in the back end.

A user recently challenged me to make the “Focus Mode” more visible; according to her, the button was hard to find for first-time users. I remembered then that many web pages’ user interface (UI) has a small walkthrough for first-time users, so I tried to replicate this in Power BI.

After a couple…


You can get the files of this story (and other useful resources) by subscribing to the PowPCo Newsletter. https://www.powp.co/powpco-signup-newsletter-form/

This story is intended to share small bits of code that I have found extremely useful in my day to day activities as a Power BI consultant.

The piece divided in a DAX and a M Query section, each bit has an identifier that is related to the sample files which can be obtained by subscribing to the PowPCo Newsletter.

M Query

M-001 Filtering multiple elements

When filtering multiple elements of columns, use List.Contains in your code rather than or.


Power BI for the Team Coach

Background

I believe that out in the wild exists an abundance of potential and opportunity accessible only to well-functioning teams. The organizations willing to confront the difficulties that making and keeping up top-performing groups will take advantage of these immense sources and be the ones to gather the benefits and transcend.

Be that as it may, what makes a team resilient and effective? For what reason is it so pleasant to work for certain groups but torture work with others? How do I, as a consultant, support dysfunctional teams in turning the boat? …


“If I have seen further it is by standing on the shoulders of Giants” — Isaac Newton

When talking about M Query, Chris Webb is one of the greatest gurus out there sharing knowledge for the sake of the greater good.

In 2015, Chris Webb wrote the post “Nested Calculations in Power Query,” which I have found super helpful many times; today, I want to share with you two real-life cases where it came very handy.

I will not go into detail about the code, as his original post covers this with great clarity; this post is intended two show…


How to start your next great report/dashboard/app

(Very) Simple to use Wireframing elements

Download files from here. https://bit.ly/2Jfqn5B

  1. Open a new power Point Project.
  2. Start pulling the elements you need to wireframe into the PPT slides.
  3. Collaborate.
PPT is a great tool to start wireframing

Top left.

It is recommended that the most important content is localized in the top left section of the dashboard.

Three recommended steps for wireframing your Power Platform/Power BI Projects.

1. Discovery call: This is around one hour call where the user shows us the current reports and data sources, here we try to understand as best as we can the needs and wishes of the end-user.

2. Wireframing workshop: this is all about the “vision.” …


Or how I call it: How not to f**k it up big time again.

I often use Embedded Power BI to test the fun stuff reserved to Premium users; I also warn my colleagues that use this capacity to remember turning it off as it becomes quite expensive to leave it on; well I left running the thing for two weeks.

How to avoid doing the same stupid mistake

After confessing my sin to my boss, and being thankful for not being killed I started investigating how to programmatically avoid doing knucklehead stuff; fortunately, we live in a world with APIs and Power Automate.

For doing this we will need to:

1) Register an…


Two techniques for obtaining the PBI dataset’s last refresh time

Importance of the last refresh time

It is a good practice to include in your Power BI reports when was the last time the dataset got refreshed. There are several techniques for doing so.

Below, you will find two of them, both arriving to the same objective, a table with a single column containing a datetime field that updates every time the dataset refreshes.

World Time API

This is my favorite way of getting the last refresh time, because you do not have to deal with time zones adjustments. Only need to replace “Europe” for the continent we are interested in, and “Zurich” for the city.

let…


Creating your next modelling masterpiece.

It doesn’t matter if it is a drawer, room or a Power BI dataset, it is horrible to open any of these and finding a mess; then, you have to spend time searching for things that are not where they suppose, trying to decipher what the hell does anything mean, and in general wasting valuable time in cero value activities.

I consider a fundamental virtue of any BI professional always to aim to make a model that can be easily understood and worked by other users. We can perform multiple activities to achieve such a goal. …

Oscar Martinez

Consultant, Business Intelligence, data, and analytics.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store