Call today 0845 643 6463

Dashboarding and Reporting

  • Fill Blank Rows With Previous Non-Blank Values – DAX

    Fill Blank Rows With Previous Non-Blank Values - DAXSeptember 5th, 2025 in Blog, Business Intelligence, Dashboarding and Reporting, DAX, Power BI, PowerBI

    Fill Blank Rows With Previous Non-Blank Values – DAX I want to see a value for everyday, whether a new value exists or not – lets call it tracking the members of a golf club. If there are no changes to the member numbers, I would have no movement figure on that day. If someone joined or left, the figure would be updated. Just because there are no changes, it doesn’t mean that there are no members on that date and therefore this day is…

    » Read more

  • From Practical to Impactful: Using Base64 Encoded Images to Transform Power BI Button Slicers

    From Practical to Impactful: Using Base64 Encoded Images to Transform Power BI Button SlicersMarch 25th, 2025 in Blog, Dashboarding and Reporting, Microsoft Fabric, Power BI

    Slicers are a key component within a Power BI report. They enable the user to intuitively explore their data and interact with visuals to reveal insights and patterns. The Button Slicer is a great choice to elevate the interactivity of a report whilst also boosting the visual impact, as it can be customized in a multitude of ways. In this blog I will show you how to use images in your Button Slicer to take your Power BI reports to the next…

    » Read more

  • Creating calendar tables with DAX using Power BI

    April 6th, 2020 in Blog, Business Intelligence, Dashboarding and Reporting, Power BI

    By Nick Edwards In this blog post we’ll take a quick look at creating a self-generating calendar table using DAX. Dates are important if we want to perform time intelligence reporting on our data i.e. yearly sales, monthly sales, weekly sales, year to date sales or previous year sales. We’ll be using the calendar function to create our date table, but there are other methods to do this such as CALENDARAUTO or GENERATESERIES. Here is the…

    » Read more

  • First thoughts on DataZen

    May 20th, 2015 in Blog, Business Intelligence, Dashboarding and Reporting

    Following the recent announcement of Microsoft acquiring DataZen, I’ve been having a play around to see what it can and can’t do. Here’s a very brief summary so far: The Good: Very quick and easy design interface Fantastic way of modifying dashboard layout for tablets and mobile devices It seems to ‘just work’ very well You don’t have to worry about the pixel perfect layout of what’s where, it takes care…

    » Read more

  • Excel creates inefficient MDX

    May 5th, 2015 in Analysis Services, Blog, Dashboarding and Reporting

    Whilst investigating a slow set of Excel pivot tables (connected to a multidimensional SSAS cube), I found some odd behaviour in how Excel generates its MDX, sometimes doing far more work than if required and causing significant performance reduction. Take the following example, just querying Customer Count by Promotion, against the AdventureWorks cube. The profile trace (just using “Query Begin”, “Query End” and…

    » Read more

  • Microsoft Acquires Datazen

    April 16th, 2015 in Analysis Services, Blog, Dashboarding and Reporting

    Exciting news in the Microsoft Analytics space. On 14th April 2015 Microsoft announced they are acquiring Datazen – what does this mean, and is it a good or a bad thing? For all of PowerView’s good points, it’s still a very immature product. I’ve still not had a single customer take it seriously, aside from a few proof of concept implementations. It’s a good ‘personal analytics’ tool, but in my opinion…

    » Read more