Skip to content
Power of Business Intelligence

Power of Business Intelligence

Blog by Andrzej Leszkiewicz. Excel VBA and Power BI developer and consultant.

  • Books to Read
  • COVID-19 report
  • Bad and Good charts in Power BI
Power of Business Intelligence

Power of Business Intelligence

Blog by Andrzej Leszkiewicz. Excel VBA and Power BI developer and consultant.

  • Books to Read
  • COVID-19 report
  • Bad and Good charts in Power BI

Category: Tricks and Workarounds

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

1 Comment 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

  • Backup/restore all calculation groups (workaround required for some visuals)
  • Adding handwriting comments and drawings to Power BI report
  • Gauge – Bad and Good Power BI Charts
  • 100% Stacked Column Chart – Bad and Good Charts in Power BI
  • Power BI Map: bad or good?

Categories

  • Books
  • Data Modeling
  • Data Preparation
  • Data Visualization
  • Excel
  • Freelance Consulting
  • Power BI Jobs
  • PowerShell
  • Sharing and Embedding
  • Storytelling with data
  • Tricks and Workarounds
  • Uncategorized

Tags

3D Alberto Ferrari animation choropleth map Cloud Scope COVID-19 data management DAX Gil Raviv good and bad charts hierarchy bridge Icon Map Image map maps Marco Russo navigation Pie Chart Publish to web recursive hierarchy Scatter Chart security SQL Stephen Few URL parameters VBA

Archives

  • September 2021
  • August 2021
  • July 2021
  • June 2021
  • April 2021
  • March 2021
  • February 2021
  • January 2021
  • November 2020
  • August 2020
  • July 2020
  • June 2020
  • Books to Read
  • COVID-19 report
  • Bad and Good charts in Power BI
Proudly powered by WordPress | Theme: BusinessDeal | By ThemeSpiral.com.