SQLBI Newsletter #220

NEW ARTICLE

Hiding measures by using object-level security in Power BI

This article describes how to hide measures from a group of users by leveraging object-level security in Power BI and Analysis Services.
Read more

DAX PATTERNS

ABC Classification

A typical example of ABC classification is the segmentation of products based on sales.

#220 · Jul 2022

LEARNING

Course calendar

Mastering DAX

	Aug 29-31 - Munich
	Sep 28-30 - Brisbane
	Oct 4-6 - Melbourne
	Oct 4-6 - Amsterdam
	Oct 10-12 - Sydney
	Nov 9-11 - Chicago

Data modeling

	Nov 9-11 - Chicago
	Dec 5-7 - Amsterdam

video courses

	Mastering Tabular
	Intro to Data Modeling
	Data Modeling for Power BI
	Power BI Dashboard Design
	DAX Tools
	Introducing DAX
	Mastering DAX
	Optimizing DAX
	Power Pivot

The best-selling products that contribute to up to 70% of the total sales belong to cluster A. The products making up the next 20% of sales are in cluster B, whereas the products representing the last 10% of sales belong to cluster C.
Read more

BI-WEEKLY NEWS DIGEST

Latest news

	• Preview data in the dataset details page Users with build permissions can display a content preview of a dataset's tables, and also create formatted tables. Jun 22, 2022 · Microsoft
	• Emulating PivotTables and PivotCharts in Power BI In Power BI, by playing with the Field Parameters you can create a user experience similar to PivotTables and PivotCharts in Excel. Jun 21, 2022 · Sam Fischer
	• Making switchable charts in Power BI with Deneb Deneb is a flexible custom visual that can use alternative ways (other than bookmarks and fields parameters) to customize the chart type being displayed. And if you know of Deneb, it is time to try it. Jun 20, 2022 · Daniel Marsh-Patrick
	• Visualize Power BI dependencies with Tabular Editor and Mermaid Tabular Editor shows measures dependencies using text only, but thanks to its scripting capabilities, you can easily create a dependency diagram. Extremely useful! Jun 28, 2022 · Kurt Buhler

SQLBI YOUTUBE CHANNEL