SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Power BI Desktop May 2016 Update Info: Conditional Formatting and Quick Calc

*Update: The Power BI team has finally published a blog post with all the new features and its glorious! Read about all the new enhancements and changes to Power BI Desktop right here.

So it appears that the May 2016 update to Power BI Desktop has dropped without any notification from the Power BI team on their blog or  a notification within Power BI Deskop. So I figured I’d take a moment to point out of the new enhancements to Power BI Desktop.

New to Power BI Desktop? Get started here.

1. Conditional Formatting on Tables

This one is awesome and has been a feature that we’ve all been waiting on for a while. We now have the ability to apply conditional formatting on a field based on a numeric value, as seen in the screenshot below.


To configure the conditional formatting on your Table, click the drop down arrow on the numeric field and select Conditional Formatting.


In the Conditional Formatting options, the formatting is based on the Base Value, which at this time appears to be limited to the field you’re applying the conditional formatting. The formatting can be based on the highest and lowest values in the column or on absolute values that you specify.

You can also use diverging colors, as seen here:



2. Quick Calc

Quick Calc is a new feature that easily allows us to create calculations by numeric measures in our data without having to write DAX. To see the new Quick Calc feature, select the drop down arrow next to the numeric field you want to use.


This will open the Quick Calc dialogue box:


Now we can quickly choose to show a value as a calculation of the percent of grand total.


Previously we’d have to write some DAX to calculate this, but now we can do this much more easily and give our users the ability to look at their data in a couple different ways. I would imagine that the Power BI team has plans to add additional capabilities to this feature.

Also, the conditional formatting can be configured from within the Power BI Service. ??

3. Publish Power BI Desktop to Pyramid Analytics Server w/ Live SSAS Connection

This is a new feature to this release of Power BI Desktop that Dan English (twitter | blog) pointed out. If your organization is leveraging Pyramid Analytics Server, you now have the capability to publish your Power BI Desktop files with a live connection to SQL Server Analysis Services to your Pyramid Analytics Server Instance. Pretty neat!

publish to pyramid

For more information on Power BI and Pyramid Analytics, check this out.


I’m pretty excited about the new features, but I’m really looking forward to the announcement from the Power BI team on these features and other new features we may have missed. So what are your thoughts on these new features? Leave me a comment and let me know.

And if you found any other features in this month’s update that I missed, definitely leave a comment and let me know!

SQL with Dustin Ryan

Dustin Ryan is a Data Platform Solution Architect on the Education Specialist Team Unit at Microsoft. Dustin has worked in the business intelligence and data warehousing field since 2008, has spoken at community events such as Code Camp, SQL Saturday, SQL Rally, and PASS Summit, and has a wide range of experience using the Microsoft business intelligence stack of products across multiple industries. Prior to his time at Microsoft, Dustin worked as a business intelligence consultant and trainer for Pragmatic Works, a Microsoft partner. Dustin is also an author, contributor and technical editor of books such as Applied Microsoft Business Intelligence, Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX, and others. You can learn more about Dustin at http://SQLDusty.com.


Leave a comment on the original post [sqldusty.com, opens in a new window]

Loading comments...