In this article, we tackle the growing issue of ‘report-specific objects’, dataset measures and tables created to fill specific report visual requirements, why they negatively impact self-service users, and best practices to mitigate this impact.

A challenge to which I infrequently return is attempting to create various “new” chart types using only Power BI’s native visuals. For example, I have tried to replicate a Horizon…

Welcome to a new series that I’m starting with a few colleagues at Pragmatic Works. The goal of this series is to document many design practices and solutions to problems that we often run into wit…

Did you know that it’s easy to transform Power BI’s Line Chart into a Slopegraph? No DAX or fancy workarounds are required. Slopegraphs are a great way to judge the rate and magnitude o…

I was helping out in the Power BI Community and I came across the following requirement. The user had sales figures and based on the Previous month, they wanted to have an arrow showing if it was u…

We show you how to use a KPI or card as a slicer.

NAME: Arrow Rating   DESCRIPTION: This quick measure shows an up arrow or down arrow when comparing a target value against a target value, or else "--" if not. Can also be inverted if a lower value is better compared to the target.   PARAMETERS: Name: Base Value Tooltip: Your base value / measure. T...

A few weeks ago I was asked whether it was possible to display line breaks in text in a Power BI visualisation. It turns out it isn’t possible – at the moment Power BI always strips line breaks out…

As I remember managers used to love SSRS reports for their availability of traffic light indicators which are useful way of measuring KPIs, trends etc. During my recent Power BI engagements with clients I have been asked few times if similar can be achieved in Power BI and my answer to that was, y...

For me, Stephen Few has always been the guru of Data visualisations. Recently, while I was reading one of his paper, I came across most talked Bullet Chart and Highlighting a…

PowerBI allows users to add measures to tooltips. Many users want to add text columns as well. Today if you drag a text column to the tooltips, a count measure is created which is not very useful. …

The Power BI team recently announced the release of the Pulse Chart custom visual. Excited by its potential, I decided to show you today how to define dynamic events, so your Pulse Chart will always trigger popups with top events, no matter how you slice and dice the report. For example, in the dashboard that we will create today, you …

Workaround for some missing basic Power BI functionality: Right aligning text and dealing with mixed number formats within one column.