Show Values in Rows in Power BI
This quick guide shows you how to show values in rows in the matrix visual in Power BI You will learn how to switch values on show in rows in a matrix, like this example The Matrix visual in Power BI is similar to a Pivot Table in Excel, but not quite as intuitive, which […]
Change the data source in Power BI
Sometimes you need to change the data source in Power BI from a static data source such as a CSV file to a SQL connection Here is an efficient way to do it to save you time and headaches This guide shows you a quick and easy way to make the change without having to […]
How to sort dates in Power BI
Working with dates can sometimes be a little challenging, this quick guide shows you how to sort dates in Power BI Its not always obvious how to do simple things like sort months in calendar or chronological order Here we show some simple tips using a date dimension table If you want to know how […]
Power BI Tooltips
Advanced Power BI Tooltips Power BI by default gives you basic tooltips, which present you with the values included in your visual These are limited initially to the fields and values that have been used in creating that visual Add other fields into the tooltips You can easily add other fields by dragging […]
Conditional Format a line chart in Power BI
How to Conditional format a line chart in Power BI (This is a workaround to show you how you can conditional format a line chart in Power BI) Power BI does not at first seem to have an option to add conditional formatting to a line chart, but, there is a way to make it […]
Add a date dimension table in Power BI
How to easily add a date dimension table in Power BI in 1 minute What is a date dimension table A date dimension or calendar dimension is one of the most common tables in a reporting data model. It contains one row per date. It also has all different date attributes and classifications that you […]
Our 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, […]
Data Visualisation Best Practice
This is our data visualisation best practice guide it brings together some of our favourite tips and techniques to help you create better reports and dashboards Data Visualisation Best Practice Contents Have a PLAN Know your audience What type of dashboard? Data Types Use Appropriate Charts and Graphs Make best use of space Refine the […]
