SQLBI Newsletter #146

NEW ARTICLE

Creating a slicer that
filters multiple columns
in Power BI

This article describes how to create a slicer showing the values of multiple columns, applying the filter on any of the underlying columns. Read more »

#146 – Sep 2019

DATA MODELING

	Oct 30-Nov 1 - San Francisco
	Nov 26-28 - Amsterdam

MASTERING DAX

	Sep 17-19 - Chicago
	Oct 1-3 - Amster
	Oct 2-4 - Denver
	Oct 8-10 - Washington
	Oct 8-10 - Amsterdam
	Oct 22-24 - Copenhagen
	Nov 12-14 - Toronto
	Dec 10-12 - Amsterdam

VIDEO COURSES

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

COURSES HIGHLIGHT

Upcoming DAX courses

• Last few days of early bird for courses in October:

Denver, CO, US – Oct 2-4

Washington, DC, US – Oct 8-10

Amsterdam, NL – Oct 8-10 (new date!)

NEWS DIGEST

Latest news on BI

	• Customize branding of Power BI service You can make your marketing team happy by customizing the branding of Power BI Service: logo, cover image, and theme color are your choice now. Read more »
	• New look in Power BI mobile The Power BI mobile app has a "new look" in preview. It includes the new customized branding assigned to Power BI service (see previous news) and it shows a better preview of the reports in home page. That's a very good reason to use this app. Just take care of the preview if you have sensitive data you don't want to show in home page! Read more »
	• URL parameters for paginated reports Paginated reports in Power BI service now support parameters in the URL. This also includes the ability to specify the rendering type in the URL, getting a PDF using a single link. The next step is a full integration with Power BI reports. And we are still waiting for paginated reports in Power BI Pro, of course. Read more »
	• Chart.xkcd for Power BI If you read xkcd.com, you need this custom visual that creates charts using the same style used by the webcomic. If you don't like the style, just skip to the next news. Otherwise, you probably want to use this visual to make your next presentation to a geeks audience. Read more »
	• Analysis Service 2019 RC1 available Analysis Services 2019 is still in preview but it is now feature complete. The recently released RC1 includes custom order for calculation items in calculation groups and other improvements for scalability and performance. These features are already available in Azure Analysis Services, too. Read more »
	• Setting Azure Analysis Services properties not visible in SSMS Chris Webb wrote a precious blog post explaining how to modify server properties for Azure Analysis Services that are not visible in SQL Server Management Studio. For example, you can customize MaxIntermediateRowsetSize for DirectQuery – important tweaks that could be necessary one day. Read more »
	• First review of The Definitive Guide to DAX Well, this is not a review. Chris Webb explains the three possible answers to the question "Did you know that the second edition of The Definitive Guide To DAX has just been published?". We approve his answers! Read more »

Back to school, back to study

Did you enjoy summer holidays? Good! Now it's time to read the articles you might have missed in the last few months:

• Blank row in DAX

• Filtering the Top 3 products for each category in Power BI

• Using CONCATENATEX in measures

• Syncing slicers in Power BI

• Importing Performance Analyzer data into DAX Studio

• A complete series about calculation groups

You are receiving this email because we have registered your interest in SQLBI.
unsubscribe me - Privacy Policy