SQLBI Newsletter #181

NEW ARTICLE

Filtering the top products alongside the other products in Power BI

This article shows an optimized DAX technique to display the first N products for each category in Power BI, adding a row that aggregates the value for all the other products. The companion video introduces the scenario and the general approach, while the article offers further insights and optimization solutions.
Read more

#181 · Jan 2021

LEARNING

Course calendar

video courses

	DAX Patterns collection
	Intro to Data Modeling
	Data Modeling for Power BI
	Power BI Dashboard Design
	Introducing DAX
	Mastering DAX 2
	Optimizing DAX
	SSAS Tabular
	Power Pivot

NEW POST

What has happened in the DAX world in 2020

There was nothing normal about this year, and we acknowledge that. Hoping in a better 2021, here is what happened in the DAX world, and what to expect in 2021.
Read more

SQLBI YOUTUBE CHANNEL

Latest news

	• Dataset hub preview in Power BI services You have a new menu item in the Power BI service, showing all the datasets regardless of the workspace. A better entry point to create new Excel and Power BI reports. Dec 21, 2020 · Microsoft
	• Using small multiples in Power BI to improve report performance The small multiples feature released in Power BI December 2020 makes it possible to optimize reports that have multiple charts. The feature is not available for card visuals, but you can always use the free certified Card with States visual to do that. Dec 20, 2020 · Chris Webb
	• Power BI translations and the XMLA endpoint You can translate table, measure, and column names in Power BI by using the XMLA endpoint. Now that Power BI Premium per User makes the feature available to a larger audience, you can follow this step-by-step guide to discover how to manage translations with Tabular Editor. Dec 22, 2020 · Philipp Lenz
	• Data modeling essentials & best practices We will never get tired to say that a good data model is the first step to create fast reports and to reduce the DAX code required. This article is part of the "Doing Power BI the right way" series that describes many best practices for your Power BI reports. Dec 31, 2020 · Paul Turley

View Web Version · Change Email Preferences · Unsubscribe

You are receiving this email because you have registered to a mailing list from sqlbi.com. If you would like to avoid similar emails in the future, please change your email preferences by clicking the link above.