• Home
  • Modeling for BI
  • DBA
  • Azure
  • SSIS
  • SSAS
  • SSRS - Reporting
  • PBI - Analytics
  • Consulting
  • About
Microsoft Data & AI

Power BI

Fun with Power View I: Enhance your report with Tiles, Slicers, and a Play Axis

1/17/2016

0 Comments

 
I am frequently asked, "How can i dress up my Power View report?"  In return, I end up sending an e-mail that I typed up the first time someone wanted formatting tips for Power View.  You can consider these "beginner tips", but hey, we all begin at some time!

​For a deeper dive into Power View, I recommend Brian Larson's book Visualizing Data with Microsoft Power View.  If you have a bit of initiative and want to have a little fun, just read below.


Tiles
These are a filtering option in Power View.  I think of tiles are visually appealing slicers.  Click onto a column in a Power View  data table.  From the Design Ribbon, click Tiles.  A second option is to add a tile directly in the  Power View Fields window. under Tile By. 
Picture
The result should be "tiles" running across the top of your table.  The tile "United States" is highlighted below.
Picture
If you have a tile attribute that is "unknown" or "n/a", use filters to remove it.  If you do not see a Filters bar in your Power View work space, go to the Power View ribbon and click on Filters Area.  Expand the Filters Area and click on Table.  All the column in your data table should now be visible.  Expand the column attribute you wish to filter and mark EVERYTHING BUT the offending tile code or description.  In the screen print below, every country but Australia will show up in the tile list.
Picture
Slicers
Slicers are a second way of filtering Power View.  The difference between slicers and tiles is visualization, and for me, the amount of screen real estate I can afford to give up for the cause.  Create a slicer by first creating a data table with a single attribute / column.  The new table is now an attribute list.
Picture
With the new data table selected, on the Design ribbon, click the Slicer button.
Picture
Now the Power View report has a slicer!  Note the blue boxes showing next to each attribute.
Picture
Play Axis
The short step-by-step version is as follows
1.    Add a Scatter chart to your Power View design area.
2.    Set your ‘x’ and ‘y’ axis values.
3.    Select your Details property to control what your bubble represents.
4.    Select your Size attribute to control the size of the bubbles.
5.    Generally select a month, quarter or year as your Play Axis.
6.    Click the <Play> button located to the lower left corner of the scatter chart and watch the buggles move systematically across the time element selected in the Play Axis.
Picture
Having a bunch of bubbles jump around haphazardly isn’t very informative, so you’ll want to pick values that gradually move over time.
Picture
For more fun with Power View, see Fun with Power View II: Enhance your report with Pop Outs, Themes, and font changes.
0 Comments



Leave a Reply.

    Categories

    All
    Power BI
    R Scripting

    RSS Feed

    Tweets by @SqlServerSME
Powered by Create your own unique website with customizable templates.
  • Home
  • Modeling for BI
  • DBA
  • Azure
  • SSIS
  • SSAS
  • SSRS - Reporting
  • PBI - Analytics
  • Consulting
  • About