A Table of Measures

SHERRY PARKER (The Greenbrier Companies) – A Table of Measures

When replicating business reports in Power BI it often comes up that we need to display a group of measures in a table view.  It is not possible to simply drag a variety of measures into the table view and see them in a “list” format they same way you can in Excel.  There is, however, a trick using the DAX SWITCH function that can be utilized to achieve this goal providing your end user with the look they have requested.  She will walk through how to implement this approach for monthly reporting.

Sherry Parker is a BI Analyst with years of experience in reporting Manufacturing data, starting in Excel and moving to Power BI for the last two years.  She has worked at local manufacturing companies for the last 20 years, and is currently at The Greenbrier Companies as a BI Analyst.  The Greenbrier Companies, headquartered in Lake Oswego, Oregon, is a leading international supplier of equipment and services to the freight rail transportation markets.

Portland Power BI User Group

Portland Power BI User Group

The Portland Power BI User Group is a community of people excited about the business analytics tool, Power BI. We believe the platform offers rich possibilities, and we keep pace by sharing our learning and doing deep-dive explorations of topics. We run the gamut from new to experienced users and welcome anyone who shares an interest in data analytics. Some great perks to joining our monthly meetups are networking, knowledge transfer, and community building. We aim to foster a vibrant community that shares success in implementing best practices for Power BI. Complimentary pizza and refreshments are served at every meetup.
Share on twitter
Share on facebook
Share on linkedin
Share on email


Subscribe to CSG. We’ll supply your inbox with the latest blog posts, training videos, and upcoming events.

Ready to wrangle your data?