O'Reilly logo

Microsoft Tabular Modeling Cookbook by Paul te Braak

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Working with table behavior and card control

PowerPivot is very flexible for summarizing and aggregating data—most of the time, we want to see that data at an aggregated level and at other times, it may be required at a detailed level. This recipe looks at how to specify table properties so that data is listed distinctively.

Finally, the recipe introduces a Card control that lists data into a distinctive group for display.

Getting ready

This recipe uses the Sales Model 2013.xlsx workbook available from the online content. There is no dependency on prior recipes.

How to do it…

This recipe commences on the assumption that there is no table behavior set on the Products table. First, we ensure that any formats from prior recipes are discarded.

  1. Launch the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required