Two Ways to Create Single Value Input Slicers in Power BI!

Learn about two techniques for creating a single value input Slicer in Power BI Desktop!

The first method will apply a technique outlined in a SQLBI article (link below) that uses Tabular Editor to allow native columns (fields) to be modified to allow single value slicer types to be used with them. One consideration is that this technique is not officially supported by Microsoft.

The second method shows you an officially supported method for adding a single value input slicer. This alternative way implements a WhatIf parameter and leverages some clever DAX and relationships to achieve the same result.

RELATED CONTENT 🔗

SQLBI Single Value Slicer
HTML Content Viewer (Daniel Marsh-Patrick)

Video by: Reid Havens

(Livestream Replay) Configuring Incremental Refresh PBI-Tools - with Mathias Thierbach

ABSTRACT 📝

You've heard about Power BI Incremental Refresh for datasets but you're missing powerful tooling? pbi-tools is here to help! Learn how pbi-tools supports you manage, configure, monitor and optimize incremental refresh for your largest datasets. Ask questions and see demos how to automate deploying and refreshing incremental refresh datasets. You'll hear about refresh policies, auto-managed partitions, effective date and many more technical details.

GUEST BIO 👤

In 2015, after having spent over ten years as a Software Developer and Architect with Microsoft technologies, Mathias Thierbach moved into the Microsoft BI space. He soon landed on Power BI, but also realized quickly that the development and engineering tools and practices were nothing like the ones well established in software development. This is how pbi-tools started as a project, filling this gap in tooling. Today, leading a growing data management team at YouGov, he experiences the benefits of those efforts every day. Having open sourced the project in fall of 2021, Mathias spends a lot of his free time bringing those practices to the wider Power BI community now.

RELATED CONTENT 🔗

PBI Tools
Mathias Notes/Articles
Mathias's Twitter
Mathias's LinkedIn
Mathias's GitHub

(Livestream Replay) What's new in DAX Studio 3? - with Darren Gosbell

Join Darren Gosbell and I for this live stream and hear about what is new and improved in DAX Studio 3! You’ll discover lots of amazing new capabilities, U/I improvements, feature enhancements, and even DARK MODE. Tune in to learn more!

GUEST BIO 👤

Darren Gosbell is a Senior Program Manager on the Power BI Customer Advisory Team with a passion for Data Visualization and Data Modelling. He has been working with the Microsoft Data Platform since 1999 and has practical experience implementing data warehousing and business intelligence solutions for some of Australia’s largest corporations. Prior to joining Microsoft Darren was awarded as a Microsoft Data Platform MVP from 2006 to 2022 in recognition of his contribution to the community especially in the areas of Analysis Services and Power BI, MDX and DAX. Darren is a contributor to a number of open source projects including DAX Studio, BI Developer Extensions (formerly called BIDS Helper) and ASStoredProcedures.

RELATED CONTENT link🔗

DAX Studio
Darren's Website
Darren’s Twitter

(Livestream Replay) Enterprise-Grade Planning at Scale using Acterys in Power BI - with Martin Kratky

In this session, Martin will talk about how Acterys makes Power BI “planning-enabled” in its own unique way. He will demonstrate how you can:

• Automate the integration process for nearly any data source (ERP/ accounting / SaaS solutions) with “One-Click” Apps and Acterys’ revolutionary "Instant Link" technology.

• Leverage the Acterys planning engine that adds unparalleled planning and forecasting capabilities to the standard SQL Server platform in the cloud or on-premise

• Profit from best practice finance/operations planning, forecasting as well as legal consolidation processes tailored exactly to your needs.

• Get instant reports with a variety of proven templates for cost center planning, HR, CAPEX, Cash flow forecasting and others.

GUEST BIO 👤

After finishing his Master’s Degree in Business Administration at the University of Economics in Vienna, Martin has worked for more than 20 years in the business intelligence space. Martin serves as the Group CEO of Acterys and the consulting arm, Managility. He is also a renowned expert for Power BI, working with the application since its inception among others on the initial Power BI demo models and 9 showcase solutions. Martin is an avid mountaineer culminating in the successful ascent of Ama Dablam in 2014 and surfer.

RELATED CONTENT 🔗

Martin's LinkedIn
Company Website
Company Facebook
Company Twitter
Company LinkedIn
Company YouTube