Power BI Buttons — Every time I work creating buttons, I can’t stop humming the White Stripe song “The hardest button to button;” I believe this is because I know that creating a great button, or a collection of them, is very complicated. Today I will share a recipe for a button that I…

Foreword I’ve been involved with digitalization, techEd, and analytics for the last eight years. …

I’ve developed a Power Query function for cleaning up text columns through time. The operations the function perform are: 1. Replace characters 2. Replaces matching words 3. Remove characters 4. Trims text 5. Replace full cell contents Instead of a boring explanation, see the video below that shows how the…

Anyone that has taken care of an apple tree knows that a healthy one requires an essential element: space. A tree without enough space between its branches will lack enough air circulation needed to avoid fungus, and the flowers will not have the required sun exposure for growing delicious apples; good dashboard design works similarly; a well-designed dashboard requires space between its elements; and, in both cases (apples and…

Learning to consume APIs in Power BI has been a game-changer for me. As I started making my first API requests, a world of data/possibilities opened in front of my eyes; today I am sharing on a condensed manner what I have learned. The goal is to create a comprehensive…

“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…

“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…

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…

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. …