Call today 0845 643 6463

Tag Archive: Power BI

  • 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

  • Joe’s staying ahead in Data Analytics!

    Joe's staying ahead in Data Analytics!March 28th, 2025 in Just For Fun, News

    At Purple Frog, continuous learning and professional development are at the heart of what we do. We’re pleased to share that Joe has successfully recertified in DP-700: Analysing and Visualising Data with Microsoft Power BI! What is DP-700? DP-700 is a Microsoft certification designed for data professionals who specialise in using Power BI to analyse data, create reports, and provide valuable insights. The exam covers key topics such as: Data…

    » 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

  • Overcoming Direct Lake Connection Hurdles

    January 7th, 2025 in Blog, Data Lakehouse, Data Warehouse, Fabric, Microsoft Fabric, PowerBI

    I love organising. When it comes to Microsoft Fabric, I am no different. The addition of files was a heaven-sent for me as I could finally clear up the clutter and make a Fabric solution user friendly to navigate. This allows my end users to access the correct information when they need it, quickly and accurately. Majority of the time, the end user does not need to access the Data Warehouse or Lakehouse that is storing their data, but rather the…

    » 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

  • Deep Dive into Power BI & Fabric Governance at PASS Data Summit

    Deep Dive into Power BI & Fabric Governance at PASS Data SummitNovember 7th, 2024 in Community, News, Power BI

    We’re thrilled to share that our very own Joe recently took the stage at the PASS Data Summit to deliver an insightful session on “BI the Book: Governance, Auditing, and DR for Power BI & Fabric”… Featuring Power BI Sentinel! Why governance matters… Data governance and security are often overlooked in the initial stages of building a data environment. However, neglecting these crucial aspects can lead to…

    » Read more

  • FabCon Europe from a Community Point-of-View

    October 2nd, 2024 in Blog, Community, Fabric, Uncategorised

    A community hub at a data conference serves as a vital central point for building connections, collaboration, and innovation among attendees. The Community Lounge at FabCon Europe in Stockholm was a great example of this. It was a hive of activity across the entire event. Microsoft’s community staff, MVPs, volunteers and members all came together to provide an entertaining way to network and ensure the right people are signed up to the right…

    » Read more