Skip to content
Power of Business Intelligence

Power of Business Intelligence

Blog by Andrzej Leszkiewicz. Power BI developer and consultant.

  • Bad and Good Charts
  • Deneb and Vega
  • Vega Data Visualization Examples
  • Power BI Reports
    • COVID-19
    • Krakow Bicycle Counters
    • Population Pyramid
  • Books to Read
Power of Business Intelligence

Power of Business Intelligence

Blog by Andrzej Leszkiewicz. Power BI developer and consultant.

  • Bad and Good Charts
  • Deneb and Vega
  • Vega Data Visualization Examples
  • Power BI Reports
    • COVID-19
    • Krakow Bicycle Counters
    • Population Pyramid
  • Books to Read

Category: Tricks and Workarounds

Power BI Theme JSON tricks
Data Visualization Tricks and Workarounds

Power BI Theme JSON tricks

Andrzej Leszkiewicz September 29, 2022

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

Comment on Power BI Theme JSON tricks
Better Treemap with meaningful colors and scaling
Data Visualization Tricks and Workarounds

Better Treemap with meaningful colors and scaling

Andrzej Leszkiewicz August 30, 2022

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

Comment on Better Treemap with meaningful colors and scaling
How to Breed a Unicorn? Dumbbell Chart in Power BI
Data Visualization Tricks and Workarounds

How to Breed a Unicorn? Dumbbell Chart in Power BI

Andrzej Leszkiewicz August 18, 2022

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

Comment on How to Breed a Unicorn? Dumbbell Chart in Power BI
Tricks and Workarounds

Backup/restore all calculation groups (workaround required for some visuals)

Andrzej Leszkiewicz September 14, 2021

I needed to add a gantt chart into a report. I tried multiple visuals, but they didn’t work because they all require at least one … Read More

Comment on Backup/restore all calculation groups (workaround required for some visuals)
Power BI: HTML formatted titles
Storytelling with data Tricks and Workarounds

Power BI: HTML formatted titles

Andrzej Leszkiewicz February 21, 2021

I hope Microsoft will allow HTML or BBCode tags in titles [ideas.powerbi.com]. It will be a game changer. In many cases a formatted title replaces … Read More

Comment on Power BI: HTML formatted titles
A power BI report that displays its own metadata, including refresh history
PowerShell Tricks and Workarounds

A power BI report that displays its own metadata, including refresh history

Andrzej Leszkiewicz February 1, 2021

A crazy Power BI idea is in my head. It rather doesn’t make much practical sense, but such crazy ideas sometimes lead to useful solutions for the … Read More

2 Comments on A power BI report that displays its own metadata, including refresh history
Line and stacked column chart with outliers
Storytelling with data Tricks and Workarounds

Line and stacked column chart with outliers

Andrzej Leszkiewicz November 12, 2020

In this post I’ll show how to handle a time series of data with outliers (extremely high values). For example, number of new COVID-19 deaths … Read More

COVID-19 Comment on Line and stacked column chart with outliers
Stacked column chart conditional formatting (COVID-19 report)
Tricks and Workarounds

Stacked column chart conditional formatting (COVID-19 report)

Andrzej Leszkiewicz August 16, 2020

I have updated my COVID-19 report today. New chart design: Old chart design: Old version of the chart worked, but it wasn’t perfect because of … Read More

Comment on Stacked column chart conditional formatting (COVID-19 report)
Power BI: toggle button to switch between linear and log scale
Tricks and Workarounds

Power BI: toggle button to switch between linear and log scale

Andrzej Leszkiewicz July 9, 2020

There are 2 ways to switch between linear and log scale: we can use bookmarks to switch between 2 different charts we can use DAX … Read More

DAX 1 Comment on Power BI: toggle button to switch between linear and log scale
Simple authorization based on a slicer and DAX measures
Tricks and Workarounds

Simple authorization based on a slicer and DAX measures

Andrzej Leszkiewicz June 12, 2020

I decided to start a blog about Power BI. And while my web site is not complete yet (need some design changes, SSL certificate has … Read More

Publish to websecurity 6 Comments on Simple authorization based on a slicer and DAX measures

Follow me:

Recent Posts

  • How Charts Work: Understand and explain data with confidence by Alan Smith
  • Florence Nightingale’s Rose Diagram
  • Report insight: we placed 100 orders in March
  • US Presidential Election Results 2020 Chart
  • Power BI: advanced Radar Charts using Deneb-Vega

Categories

  • Books
  • Data Modeling
  • Data Preparation
  • Data Visualization
  • Deneb-Vega
  • Excel
  • Freelance Consulting
  • PowerShell
  • Sharing and Embedding
  • Storytelling with data
  • Tricks and Workarounds
Proudly powered by WordPress | Theme: BusinessDeal | By ThemeSpiral.com.