Power BI

You may have used the UNICHAR() function in DAX to return Unicode characters in DAX measures. If you haven’t yet read Chris Webb’s blog post on the topic, I recommend you do. But did yo…

Canvas App is no code/low code business app with which you can design the app by dragging and dropping elements onto a canvas. Canvas app is used to build mobile apps with various functionalities. …

Check this simple trick to enhance the user experience when using Fields parameter feature in Power BI

Introduction In the recent release, we have a new function called “Image” in the Create app feature of Power Apps using which it’s now possible to create a Canvas app by just uploading an image of an app or form. Also, it will help app-makers to easily turn their designs or sketches into working ap

Power Automate for desktop comes with new additions in June 2022 release, including the support of more data types for input and output variables and the ability to trigger desktop flows via an external link.

Why do you need Animated GIF’s? There may come a time when your users are using your Power App where they are waiting for something to happen. More specifically, the app maybe loading data or you want to show a success screen before returning to a main menu. Out of the box, Power Apps doesn’t …

Using this feature effectively can have the biggest impact on your organizations use of data and exponentially increase to value you generate.

Conditional formatting is an easy way to highlight values so report users can receive quick insights on the status of key metrics. In this post, I will be showing a way to apply dynamic conditional formatting on visuals with set thresholds. This will...

Introduction to a series of articles that provide a high-level methodology for planning, preparing, and running an effective Azure Synapse Analytics proof of concept project.

Azure Synapse Analytics June 2022 Update Welcome to the June 2022 Azure Synapse Analytics update! This month, you will find information about the Azure Synapse Success by Design playbook and rerunning pipelines with new parameters. Additional general updates and new features in SQL, Synapse Data Exp...

Power BI is full of hidden gems! This one can literally make you a real Power BI hero out of nowhere!

Data literacy is the ability to read, understand, and use data to drive decisions. Find your data literacy persona by taking this assessment.

Presenting data with empathy and context leads business users to better decision-making.

The SWITCH function in DAX has been optimized over the years, and it is helpful to know what makes the optimization work best. The SWITCH function in DAX is widely used to define different execution paths depending on the condition of an expression. A very common case is when we want to check the sta

Read MoreTop Considerations for Delivering an Efficient Hybrid WorkplaceOver the last two years, the importance of optimizing efficiency and productivity in the Hybrid Workplace has become an …

As a non-profit operating for over 25 years, Call2Recycle helps consumers and over 200 battery and battery-powered product companies keep batteries out of landfills. They partnered with EFOQUS to digitize their sales, finance and operations processes using Dynamics 365 Business Central and Dynamics 365 Sales. This blog post describes how they used Power Pages to extend their existing system with an external facing portal that facilitates enrollment and training of e-bike retailers.

Best practices for designing and developing complex dataflows

Best practices for reusing dataflows across environments and workspaces

Learn how Power BI self-service data preparation is about using dataflows to centralize data cleansing and transformation work.

Power Apps Default Icons If you’ve built a Power App, it’s highly likely that you have explored Power Apps default library of Icons and used them. Whilst the list of useable icons is consistently growing and do include adjustable properties such as fill and outline colour, they are quite boring, standard and not out to …

Creating custom visuals using the Charticulator in Power BI is not easy. So here are some some Charticulator resources I've used to skill up.

This post explains what report level measures are, when, and how we can use them in a Power BI thin report.

Finding the main bottleneck in your Power BI report may be a challenging task. Learn how to quickly identify the poor performing report elements and how to improve the overall performance by applying some clever tricks!

We are introducing a new mechanism to include Global parameters in the ARM templates (from 'Manage hub' -' ARM template' - 'Include global parameters in ARM template').   It solves the earlier known issue, which overrode some Data Factory level configurations during deployments if the global pa...

Hey folks, if you know me, you probably know I am very interested into playing, watching or talking about football (or “soccer”). After decades my home club finaly reached again the seventh German ‘Bezirksliga’ and a German community platform and news publisher “FuPa.net” about amateurs football was looking for suggestions how to split the league. So I decided to make my suggestion and building a Power BI report to help me and also make it visual. Today we will learn about the German football leagues, Power BI, Geocoodinates and how to calculate distances, Power BI Bookmarks, how to use custom functions and make API calls in Power BI and to get some webbrowser content using Power Automate Desktop.

Normalizing conditional formatting bars in Power BI is not easy, but can be done with a measure and a calculation group. No more bars covering the values.