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 […]
Tables in Excel
What are the top 10 reasons to use tables in Excel? Tables in excel are a great way to begin to add data structure, improving consistency and reliability of the data What are Tables in Excel? The Excel table is a powerful feature that lets you sort, organize, and analyse a set of data. It […]
SQL Timesaver – Add comma separators
This one-minute SQL timesaver showcases a free online comma separator tool, designed to simplify the process of adding comma separators to your SQL code. Delim.co is a Free Comma Separating Tool that separates one or more characters and text strings using delimiters such as commas (,), semicolon (;), quotes (\”, ‘), braces ({}), pipes (|), […]
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 […]
Top 5 SQL Time savers of 2022
Here are our top 5 SQL Time saver videos on YouTube for 2022 based on the most watched Number 5 How to quickly add comma separators in SQL First published on 13th December 2022 This video demonstrates a free tool to add commas to a list of field values. The video shows this being used […]
