Power BI Desktop May Update

Microsoft released the May update for Power BI Desktop today.  See https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-feature-summary/ for details.

The date slicer has been enhanced to support relative dates, such as Last 3 years, in addition to absolute dates.  It is very flexible allowing you the choice of days, weeks, months and years.  Weeks, months, and years also have the Calendar options which indicates to exclude the current period and only included completed periods.  This feature is in preview so you will need to enable it using File > Options and settings > Options > Preview Features > Relative date slicer.  See this video to learn more.

Another nice feature now in preview is the new table visual.  This lets you setup word wrapping for a table's header and data, letting you make better use of screen real estate.  For example, see the screenshot below or go to Power BI Gurus College Finder to see it live.

 
 
The new table also supports cross-highlighting.  For example, selecting my alma mater, Rensselear Polytechnic Institute selects it on the map and shows it is in beautiful Troy, NY.
 
 
 


Comments

Post a Comment

Popular posts from this blog

Jumping into Azure Data Lake

Image
Introduction You may have heard of Data Lakes and are wondering if it is the next big thing.   This post will provide an overview of Azure Data Lake, how to use it and some of its pros and cons. History of Data Lakes and Azure Data Lake The Data Lake term was coined by Pentaho in October 2010 to address limitations of a data mart, which typically has a subset of attributes and is aggregated.   Per Jamie Dixon’b Blog, the lake terminology was chosen since “the contents of the data lake stream in from a source to fill a lake, and various users of the lake can come to examine, dive in, or take samples.” Microsoft’s Azure Data Lake became generally available in November 2016, as described in this post: https://azure.microsoft.com/en-us/blog/the-intelligent-data-lake/ .   There are really three services that make up the data lake as shown in the diagram below.   The underlying technology for the data lake is based on Hadoop, but as an end user that is transparent.   You
Read more

Identifying Possible Price Fixing in the market of Ethacrynic Acid 25 MG tablets

  Executive Summary Ethacrynic Acid 25 MG tablets is the generic form of Edecrin, a loop diuretic that was originally approved by the FDA in 1967.   Ethacrynic Acid is the only loop diuretic that does not contain sulfa, so there are no substitutes for patients that need a loop diuretic but are sensitive to sulfa. There are multiple generic manufacturers of Ethacrynic Acid 25 MG tablets.   However, data from the National Average Drug Acquisition Cost provided by the Centers for Medicare and Medicaid Services show that the prices fluctuate over time but consistently move in lockstep.   Given the significant fluctuation in prices, the only rational conclusion is that the generic drug makers are colluding to fix the price at an artificially high level.   Background Etacrynic acid (INN) or ethacrynic acid (USAN), trade name Edecrin, is a loop diuretic used to treat high blood pressure and the swelling caused by diseases like congestive heart failure, liver failure, and kidney fail
Read more

Power BI Licensing Basics

Microsoft Power BI Licensing Basics Introduction Microsoft Power BI's licensing has evolved over time and can be a bit confusing.  The goal of this post is to clear up the confusion. Power BI Publishers vs. Consumers Within your organization there will typically be two categories of Power BI users: publishers and consumers.  Publishers are creating reports using Power BI Desktop and publishing them to the Power BI Service.  Consumers are viewing the reports and dashboards on the Power BI Service and interacting with them. Licensing Requirements Each publisher will need a Power BI Pro license.  The licensing for consumers is where it gets more interesting.  Each consumer also needs a Power BI Pro license, unless the report is in Power BI Premium capacity.  In that case, consumers just need to be assigned a Power BI Free license. Power BI Premium When you purchase Power BI Premium, you are buying capacity in the Microsoft Azure cloud, not a license.  There is no limi
Read more