Select Distinct Logo Clear Background

Business Analytics Blog

Our Top 5 Power BI Timesavers 2022

Top 5 Power BI Timesavers 2022

Here are our top 5 Power BI Timesaver videos on YouTube for 2022

Based on the most viewed, in reverse order,

Number 5

Use conditional formatting in a line chart in Power BI

Have you ever needed to use conditional formatting on a line chart in Power BI?

Power BI does not have the option, but here is a workaround using a technique that starts off with a stacked bar chart, sets the formatting, then change to a line chart

Number 4

Power BI Tips – Switch Measures using a slicer

This short video guide shows you how to use a slicer to switch between measure values in Power BI

We use the slicers as a toggle to alter the values displayed on the charts between Sales Values, Units Sold and Gross Profit

This technique adds a great deal of flexibility and interactivity to your dashboards and can be a great way to save space

Number 3

Change the data source from CSV to SQL in Power BI

At first it looks like this option is not available in Power BI, but here we show how to do it by copying and pasting the code in the advanced editor

Doing this means that all the existing dashboard visuals still work after the new data source is applied

Number 2

Easily add a date dimension table in Power BI

Here is a very useful and repeatable timesaver for Power BI This short video shows you how to quickly create a date dimension table in Power BI Desktop

The guide has the DAX code you can copy and paste to generate the date dimension table and show you how you can customise it to your own requirements

At Number 1
Our most watched Power BI Time-saver video over the last 12 months

Data Visualisation Best Practice

Dashboards are a great way to present the data your audience needs to know. But, if they done wrong, they can do more harm than good.

This best practices guide for creating dashboards walks you through the key steps to consider when designing a dashboard.

The key to a good dashboard is to make it simple yet informative. It should be easy for your audience to understand the message you’re trying to convey and quickly take action on any insights or recommendations.

Subscribe to our channel to see more Power BI Timesavers

https://www.youtube.com/channel/UC_DiGjuhpRbv6fE8cqD4QBg

 

Our Business Analytics Timesavers are selected from our day to day analytics consultancy work and are the everyday things we see that really help analysts, SQL developers, BI Developers and many more people. Our blog has something for everyone, from tips for improving your SQL skills to posts about BI tools and techniques. We hope that you find these helpful!

Business Analytics Blog

 

By Simon Harrison

Simon Harrison Founder of Select Distinct Limited and a business intelligence expert