Tech blog with tips, tricks and hacks

Tech blog with tips, tricks and hacks

for EVs, hardware, software, home automation, programming and more

  • HOME
  • Categories
    • 3D Printing
    • Active Directory
    • Azure
    • Electric Vehicles (EV)
      • EV Charging
      • Škoda Enyaq iV
      • Tesla
    • Hardware
      • Amazon Echo / Alexa
      • Networking
      • Raspberry Pi
      • Sky / Sky+ / Sky HD / Sky Q
    • Home Automation
    • IIS
    • Mobile Devices
      • Apple iPhone and iPad
      • BlackBerry
      • Dumb devices
    • Office 365
    • Operating Systems
      • Mac OS X
      • Windows 10
      • Windows 11
      • Windows Server 2003
      • Windows Server 2008
      • Windows Server 2012
      • Windows Server 2016
      • Windows XP
    • Power BI
    • Programming
      • .net
      • C#
      • Command Prompt
      • CSS
      • HTML
      • PowerShell
      • vb.net
    • SEO
    • Software
      • Mircosoft Exchange Server
      • Microsoft Office
      • Microsoft SQL Server
      • Microsoft Teams
    • Telecoms
    • Virtualisation
    • Window Media Services
  • Contact
  • Buy me a coffee
Recent posts
  • [ 6 June 2023 ] Lightwave RF tips: Automation for dynamic LED colour based on door / window contact sensors being open / closed Home Automation
  • [ 5 June 2023 ] Smart home tips: Stop feeling clueless! Home Automation
  • [ 2 June 2023 ] Troubleshooting 8 of the most common Active Directory issues Active Directory
  • [ 2 June 2023 ] How to blur or change the background on a Teams call Microsoft Teams
  • [ 26 May 2023 ] Active Directory certificates not working Active Directory
HomePower BI

Power BI

Here, you will find a collection of articles filled with useful tips and tricks to help you get the most out of Microsoft’s powerful business intelligence tool. Whether you are a beginner looking to learn the basics, or an advanced user seeking new ways to optimize your data visualisation and analysis, you’ll find something of value here. From creating custom visualisations to automating data refreshes, we aim to cover it all. Dive in and start exploring!

Power BI tips and tricks
Power BI

Power Bi tips: 12 tips to get the most out of Power BI

16 January 2023 Richard Wallace 0

Power BI is a powerful tool for data visualisation and analysis, but it can be overwhelming for new users. Here are some hints and tips to help you get started: 1) Start with a clear […]

Power BI

Count duplicate rows in Power BI using DAX

27 January 2022 Richard Wallace 0

If you’re working with data in Power BI and would like to count how many duplicates there are, the below example will help you. Let’s start with the table structure. For this example, lets says […]

Power BI

Group values in ranges in Power BI using DAX

10 January 2022 Richard Wallace 0

If you have a column containing numeric values in your Power BI report, depending on the graph, it can sometimes be too much and produce some messy graphs, like the below: To make this look […]

LATEST POSTS

  • Home Automation

    Lightwave RF tips: Automation for dynamic LED colour based on door / window contact sensors being open / closed

    6 June 2023 0
    One of my favourite home automations uses Lightwave RF to change the LED colour on their light switches to a different colour based on the status of their contact sensors that I have in my [...]
  • Smart home tips: Stop feeling clueless!
    5 June 2023 0
  • Troubleshooting 8 of the most common Active Directory issues
    2 June 2023 0
  • How to blur or change the background on a Teams call
    2 June 2023 0
  • Active Directory certificates not working
    26 May 2023 0

POPULAR POSTS

  • 3D Printing

    OctoPrint – Flashforge Creator Pro 2

    1 March 2021 14
    Before we start, it’s important for you to note that this isn’t a supported setup for the Flashforge Creator Pro 2 to work with OctoPrint, it’s more of a work around. So it’s completely at [...]
  • Sky Q Hidden Engineers Menu
    25 April 2017 13
  • Change your Sky Q AirPlay / Bluetooth name
    4 October 2017 5
  • Download photos from Rightmove using PowerShell [updated]
    11 August 2022 5
  • Škoda order/build status codes
    2 November 2021 3

Tags

3D Printing Active Directory Ad blocking ajax Alexa c# Command Prompt Creator Pro 2 DAX Docker Electric Vehicle EV Flashforge Home Assistant Home Automation Homebridge Homekit iOS iPad iPhone LightwaveRF logon script Networking OctoPi OctoPrint office 365 PowerBI PowerShell Raspberry Pi Router Skoda Skoda Enyaq iV Tips Sky Q Sky Q Hack Sky Q Remote Control Sky Q Voice Control Teams Tesla Unifi vb.net VoIP Wi-Fi Windows 10 tips Windows 11 tips wireless networks
Support me

Buy Me a Coffee

About me

I’m Richard Wallace, an IT professional with more than 20 years experience in IT and web design.

This blog has been setup to share some of my knowledges, hacks, hints and tips.

Follow me
  • Linked In
  • Twitter
  • YouTube
  • Contact
  • Cookie Policy
  • Privacy Policy
  • Terms & Conditions

Copyright © 2023 | Richard Wallace