Power BI Freebies

Power BI & COVID19

Posted on

I created this Power BI report for a client interested in COVID19 data. Unfortunately, the work fell through but I don’t want it to go to waste. If you would like the file just download it below. Dont forget to check out all the other Power BI freebies on the site! Download the file here, […]

DAX

DAX COALESCE

Posted on

DAX, the COALESCE function Don’t you hate it when a card looks like this? Meet COALESCE This function was introduced in March 2020 and instantly became a favourite of mine.  Although I think a more appropriate name would be ifblank! Wrap it around your DAX statement and the Default Measure will be presented instead of […]

DAX

DAX YTD & LYTD

Posted on

DAX for Financial Years I use these two measures quite a bit. YTD Total Sales is straight forward and calculates in this case a sum of sales from the 1st of July to today. The trick is what to do when you want to compare the same period for the previous year. That is where […]

Updates

5 Tips to a Successful Side Hustle

Posted on

I have now been running my side hustle for 1 year now and I don’t think I have ever learnt so much. There are so many varied skills required but here is my top 5 that I believe will set you on the right path for a successful side hustle. 1. Personal Brand My number […]

Power BI Freebies

Embedded Power BI Toolbar

Posted on

Ever need more space of your embedded Power BI report? Then this trick is a great way to reduce the size of your toolbar. Follow along below and grab the pbix at the end to have a go yourself. Here is the Embedded Power BI report. Engage with the nifty toolbar to open and close […]

Power BI Freebies

Canva + Power BI

Posted on

Background Concepts for Power BI Recently I read an article on background concepts for Power BI by Chris Hamill. It touched on the importance of a report background and its role within data storytelling. It then gave a tutorial on how to create a PowerPoint background for Power BI. It really is a great article […]

Power BI

Liveability versus Density

Posted on

Liveability according to the Cambridge dictionary refers to “the degree to which a place is suitable or good for living in.” This seems straight forward but dig a little deeper and you will realise that this buzz word is harder to define than you think. What actually makes a city liveable seems to be under […]