Call today 0845 643 6463

Power BI

  • Narrate Your Data: Implementing Dynamic Alt-Text for Inclusive Reporting

    August 21st, 2025 in Blog, DAX, Power BI

    As Power BI Developers our aim is to make data insights accessible universally, so that everyone can make full use of their data and the insights it holds. Therefore it is critical to step out of our own shoes during the design process to ensure that what we build is inclusive to as many audiences as possible. In this blog I will explore how you can implement dynamic alt-text using DAX measures, which help people who are blind or have low…

    » Read more

  • Unlock Efficiency and Growth at Purple Frog’s Discovery Morning

    Unlock Efficiency and Growth at Purple Frog’s Discovery MorningMay 26th, 2025 in Artificial Intelligence, Just For Fun, Microsoft Fabric, News, Power BI

    Purple Frog is excited to invite you to a morning of insight, innovation, and inspiration at our upcoming AI & Analytics Discovery Morning. This free event is designed for business leaders, analysts, and data professionals who want to explore how AI and analytics can drive real-world results. From streamlining operations to uncovering new growth opportunities, we’ll show you how to turn data into action. You’ll gain practical knowledge…

    » Read more

  • BLANK() Function Not Working As Expected

    May 1st, 2025 in Blog, DAX, Power BI

    Trying to handle blank values in Power BI… I needed a measure that would fill blank gaps across days where a value wasn’t present – I thought the BLANK() function would help me achieve this. My goal for the results of the measure is shown below: The logic is quite simple, if the value on that day is not blank, take that value. If it is blank then take the previous non-blank value. The first piece of logic is to get the date where…

    » Read more

  • Replacing Nested IFs with SWITCH() functions in DAX

    April 17th, 2025 in Blog, DAX, Power BI

    When solving problems and requirements for reports in Power BI, there eventually comes a need for nested IF() statements in your DAX. They work just fine, until they don’t. The more conditions you add, the harder they become to read, maintain and debug. There’s a cleaner way to handle this kind of logic and it’s one that often gets overlooked: SWITCH(). Let’s take a look at why it’s worth getting familiar with and how it can make your…

    » 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

  • Stop Pressing Publish in Power BI – OneDrive or Sharepoint can do that for you

    March 12th, 2025 in Blog, Power BI, Purple Frog Systems

    If you’re still using the Publish button in Power BI Desktop, there’s a better and more efficient way to manage your reports while saving time. By leveraging OneDrive and SharePoint integration, you can speed up your workflow, reduce errors, and improve collaboration. Here’s how you can do it: Step 1: Enable Save to OneDrive and SharePoint Preview Features First, ensure that your Power BI Desktop is set up correctly: Open Power BI Desktop.…

    » Read more

  • Matt Earns Microsoft Certified: Fabric Analytics Engineer Associate Certification

    Matt Earns Microsoft Certified: Fabric Analytics Engineer Associate CertificationDecember 31st, 2024 in Fabric, Microsoft Fabric, News, Power BI

    We’re excited to share some fantastic news – Matt has officially achieved the prestigious Microsoft Certified: Fabric Analytics Engineer Associate certification! This accomplishment highlights Matt’s dedication to mastering advanced analytics and engineering skills within the Microsoft Fabric ecosystem. This certification demonstrates expertise in designing and implementing data solutions that deliver valuable insights, a critical…

    » Read more

  • Alex Presented at Bristol Fabric & Power BI User Group

    December 24th, 2024 in Community, Microsoft Fabric, News, Power BI

    On December 19th, Alex travelled from The Frogplex to Bristol to present a session at the Bristol Fabric & Power BI User Group. The focus of his presentation was on Power BI Composite and Advanced Models . The session explored how to effectively leverage these advanced techniques to handle large datasets within the Power BI environment. This includes combining diverse datasets into a single report through composite models, directly querying…

    » Read more

  • Metric Sets in Power BI

    Metric Sets In Power biDecember 24th, 2024 in Blog, Power BI

    Metric Sets in Power BI: Transforming Data Management Having reliable and consistent metrics is crucial for making informed decisions. Microsoft Power BI has introduced an enhancement with the launch of Metric Sets, now available in public preview. This innovative feature is designed to help you define, discover, and reuse trusted metrics across your organisation. It enhances your data experience and empowers you with the tools you need to…

    » Read more

  • Field Parameters in Power BI

    Field Parameters in Power BIDecember 11th, 2024 in Blog, Power BI

      Field parameters are another tool for Power BI developers to make their reports more dynamic and interactive. They are currently a preview feature as of writing this blogpost, meaning you will need to enable it in the preview settings and I will show you how to do this further on in the blog.   What Are Field Parameters? Field parameters enable report readers to switch between different fields or measures in a visual with just a…

    » Read more