Have you ever wondered how people do the trick below? Say no more! I'm going to share with you all the tricks that you need to do to achieve something like this. In my example, I created a report where you could switch the measure the charts were showing, and with that, the color of the charts and KPI cards changed to. The first thing you need to do is create your base measures. In my example my base measures were: Number of Orders = count(Amazon[Order ID]) Orders Value £ = SUM(Amazon[Amount]) I

Every day businesses are making a host of decisions—big and small. Increasingly, many of these decisions are being informed or guided by data. This article examines several potential pitfalls that can prevent data-driven decision-making (DDDM) from delivering on its full potential.

Every day businesses are making a host of decisions—big and small. Increasingly, many of these decisions are being informed or guided by data. This article examines several potential pitfalls that can prevent data-driven decision-making (DDDM) from delivering on its full potential.

In this blog post, I'm going to share with you a recent success story from one of my customers. For privacy reasons I can't mention the customer itself, but I will give you a little overview of the company and the kind of industry they are in. With this success story, I hope I can inspire readers and customers to think more carefully about their design choices when building reports in Power BI. COMPANY OVERVIEW Customer: Recruiting Analytics (for privacy reasons, I can't reveal the real name of

Learn how to use Timeline Visual in Power BI to show data per date in a timeline format | Horizontal Timeline in Power BI | Virtical Power BI Timeline visual

How to show almost 200 countries data on a treemap visual? For this experiment I took international trade statistics (merchandise exports by product group, annual) … Read More

I came across this Global Views on Abortion Report which showed the following graph: It was great to compare support for permitting abortion across different countries, but it was a little more difficult to compare support for not permitting abortion across countries. So I thought I’d have a go at modifying the chart slightly. From… Continue reading Quick Chart Makeover

What if I tell there is a way to show only the desired data labels in PowerBI and that is without any extra visuals? It can be applied to almost all the visuals I tried, just need to write DAX. There are two tricks I have used here the first trick I came across was by luck, and I am not sure if anyo

Reproducing Robert Mundigl’s variations on bullet charts using Deneb and Vega-Lite.

When I'm developing reports, I'm asked multiple times to "hide" the slicers/filters from the report page. Usually this is to make space in the page for other visuals and because customers don't want to use the filter pane for some reason. This happened so many times, and only in the last couple of months I decided to try some things out and get a bit creative with Power BI. I came up with two solutions, which I think work great in these scenarios. Remarks: - This might not working very well if y

In this article we will build a custom Power BI visual from scratch, we will build a KPI card with selections (interactivity in the…

Building a Custom Power BI Visual from scratch (KPI Card) In this article we will build a custom Power BI visual from scratch, we will build a KPI card with selections (interactivity in the dashboard), drill-through functionality, formatting options and highlighting. The code changes are kept to a m...

It started with @shan_gsd‘s tweet about Year 2022 Week 33 of the Workout Wednesday and @CJMajka‘s reply “A dumbbell chart in #PowerBI?! That is kind … Read More

Last week I introduced mini-projects as one pillar of my graduate visualization course. A interesting outgrow of that activity is a set if data visualization clarity and aesthetics guidelines we developed over time while reviewing the solutions our students submitted for these exercises.

Three concepts from visual perception that can help you think better about clarity and aesthetics

Reflections on my frustration teaching data visualization without focusing on effective data-driven thinking

Why are some visualizations so easy to understand at first sight while others seem to be some sort of graphical puzzle? Why do some visualizations need to be relearned every time you see them again, whereas others need only one simple initial exposure?

O'Reilly Resources

As a data visualization tool, Power BI provides rich visualization, self-service functionalities, as well as the ability to embed Power BI reports into your organization’s applications—a feature that …

Perhaps you would like to share your Custom Power BI visual with others online or collaborate during the development of a custom Visual. In that case, it's useful to run your visual project in Codesandbox.io so you can share your visual across platforms, like f.e. medium.   In this article, I will e...

For more formal enterprise Power BI development, many people have a checklist to ensure data acquisition and data modeling quality and performance. Fewer people have a checklist for their data visu…

Work: 17th Century Watercolors

Its about the clusters. I have created a scatter chart with the measure of Profit Margin and Revenue of y and x axis respectively.

Creating a calendar is not as complicated as you think. It requires some creativity and you could achieve it too.

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.

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.

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.