Power BI

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.

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

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

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

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

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

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

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

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

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

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

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.

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

I love Power BI community for the inspiration it gives. Today after reading this LinkedIn post by Jan Schroeven I realized that if Power BI … Read More

Share the article

Many gauge visuals take-up a significant amount of screen real estate, and I wondered if Deneb/Vega-Lite could be used to minimize the required space. Here’s what I came up with: This example uses a number of optional Deneb/Vega-Lite components, including: a title block c/w subtitle a transform block to extend the dataset a layer block with 4 specifications as follows: a bar mark for 100% width background (target) a bar mark for progress width = actual/target; percent) (actual) color = gr...

👂 Heard about Deneb but don't know where to start?💡 Tip for #deneb beginners... How import and export Deneb chart templates in Power BI (4 min)https://t.co/atT49JnwHOWhere to find chart templates in links below 👇#dataviz #Deneb #vega #powerbi— Kerry Kolosko (@KerryKolosko) October 11, 2022

Further reading and external resources for Deneb

Understanding how to work with templates in Deneb

Power BI is a powerful tool that has also enabled millions of people worldwide to easily visualize & explore their data. Despite that, inflexibility to the visualization configuration and formatting can make it difficult to fulfill visual requirements. What are some of the biggest feature g

Guidance for Power BI tenant settings.

Before Excel and other data-linked spreadsheets, business reports needed to be hand-crafted by IT experts, and changes were arbitrated slowly via change control. Power BI was designed to take the liberation that Excel pioneered to the max, by allowing 'power' users to not only to create Power BI desktop reports, graphics and visualisations in Power BI App, but then link and publish these to the Power BI app. These in turn can be given row level security and have their underlying data kept up-to-date so that users can log in and see the relevant and appropriate data in a browser. Saurabh Des...

In this series of blog posts, I will provide a step by step guide on how to become the change agent that puts your organization on a path towards continuous improvement using the most valuable decision support techniques. I prefer the term decision support over business intelligence since it emphasi...

Missed the previous parts of this series? See Become your organization’s strategic advisor by using Machine Learning and Power BI   Estimating the actual impact of an investment is an essential part of management. An investment, in this context, can be any change in resource allocation but is most o...

Power BI is a versatile tool, but there can be confusion as to who should use it and how when an organization begins to roll it out.

BI@Microsoft is a program inside Microsoft IT which is responsible for the BI tools Microsoft employees use. This blog post will look at how we are driving rapid internal adoption of Power BI and influencing the Power BI product group so that it builds a product that meets the needs of large enterprise customers.

All this talk all the time about Big Data and Advanced Analytics is all well and good, in fact it is something I do most of my time. The technology is there and has great potential. The biggest que…

We are happy to announce the technical reference implementation of an enterprise grade infrastructure to help accelerate the deployment of a BI and reporting solution to augment your data science and…

The organizational choice to implement Power BI often comes with the promise of self-service business intelligence. This can be interpreted in a number of ways, but tends to be represented as the ability of the business to query data with minimal involvement from IT. The reality, however, is not usually