Havens Consulting
Video by: Reid Havens
Here's something that trips up a lot of Power BI developers: not everything belongs in your core semantic model. Some objects are meant to live in a departmental layer. Some belong in a single report, knowing the difference changes how you build, and how well your architecture holds up over time.
In this video I walk through Power BI's extensibility layer objects: what they are, where each one belongs in your architecture, and when to actually use them.
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.
SQLBI Single Value Slicer
HTML Content Viewer (Daniel Marsh-Patrick)
Video by: Reid Havens
Signup for our mailing list to gain access to Power BI files and templates from the videos. You’ll receive a welcome email with a link and password to the Blog Files page.
Reid Havens’ early love affair with analytics has, over the past decade, turned into an evolution into data visualization and report design in Power BI.
Since then Reid has been writing articles and creating YouTube videos to share the word of BI, helping to inspire the next generation of Business Intelligence enthusiasts.
