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

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

  • It’s a client requirement. The customer is always right.
  • Power BI: HTML formatted titles
  • Elon Musk’s 12 Principles. Rocket building or data visualization?
  • 3D and animation in Power BI?
  • PowerShell script to download Power BI report from Power BI Service

Categories

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

Tags

3D Alberto Ferrari animation COVID-19 data management DAX Gil Raviv Marco Russo navigation Publish to web security SQL URL parameters VBA

Archives

  • March 2021
  • February 2021
  • January 2021
  • November 2020
  • August 2020
  • July 2020
  • June 2020
  • Books to Read
  • COVID-19 report
Proudly powered by WordPress | Theme: BusinessDeal | By ThemeSpiral.com.