Skip to main content
SpringerLink
Log in
Apress
Book cover

Pro Power BI Theme Creation

JSON Stylesheets for Automated Dashboard Formatting

  • Book
  • © 2021

Overview

Authors:
  1. Adam Aspin

    1. STAFFORD, UK

    View author publications

    You can also search for this author in PubMed   Google Scholar

  • Gives a clear, simple, and progressive introduction to a subject that is hard to understand without guidance
  • Provides a single point of reference to a subject where information is currently scattered, non-existent, or overly complex
  • Enables Power BI users and power users to save dozens, or even hundreds, of hours manually formatting dashboards

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 54.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (13 chapters)

  1. Front Matter

    Pages i-xvi
    Download chapter PDF

  2. Introduction to Power BI Themes

    • Adam Aspin
    Pages 1-9

  3. Create and Customize a Theme in Power BI Desktop

    • Adam Aspin
    Pages 11-41

  4. High-Level Theme Definition

    • Adam Aspin
    Pages 43-59

  5. Default Visual Styles

    • Adam Aspin
    Pages 61-86

  6. Object Visual Styles

    • Adam Aspin
    Pages 87-101

  7. Card and Table Visual Styles

    • Adam Aspin
    Pages 103-123

  8. Classic Chart Visual Styles

    • Adam Aspin
    Pages 125-164

  9. Complex Chart Visual Styles

    • Adam Aspin
    Pages 165-194

  10. Other Chart Visual Styles

    • Adam Aspin
    Pages 195-220

  11. Maps

    • Adam Aspin
    Pages 221-231

  12. Miscellaneous Visual Styles

    • Adam Aspin
    Pages 233-256

  13. Dashboard Styling

    • Adam Aspin
    Pages 257-281

  14. Cascading Styles

    • Adam Aspin
    Pages 283-295

  15. Back Matter

    Pages 297-303
    Download chapter PDF
Back to top

Keywords

About this book

Use JSON theme files to standardize the look of Power BI dashboards and reports. This book shows how you can create theme files using the Power BI Desktop application to define high-level formatting attributes for dashboards as well as how to tailor detailed formatting specifications for individual dashboard elements in JSON files. Standardize the look of your dashboards and apply formatting consistently over all your reports. The techniques in this book provide you with tight control over the presentation of all aspects of the Power BI dashboards and reports that you create. 
Power BI theme files use JSON (JavaScript Object Notation) as their structure, so the book includes a brief introduction to JSON as well as how it applies to Power BI themes. The book further includes a complete reference to all the current formatting definitions and JSON structures that are at your disposal for creating JSON theme files. Finally, the book includes dozens of theme files, from the simple to the most complex, that you can adopt and adapt to suit your own requirements. 




What You Will Learn
  • Produce designer output without manually formatting every individual visual in a Power BI dashboard
  • Standardize presentation for families of dashboard types
  • Switch presentation styles in a couple of clicks
  • Save dozens, or hundreds, of hours laboriously formatting dashboards
  • Define enterprise-wide presentation standards
  • Retroactively apply standard styles to existing dashboards




Who This Book Is For


Power BI users who want to save time by defining standardized formatting for their dashboards and reports, IT professionals who want to create corporate standards of dashboard presentation, and marketing and communication specialists who want to set organizational standards for dashboard delivery


Authors and Affiliations

  • STAFFORD, UK

    Adam Aspin

About the author

Adam Aspin is an independent business intelligence consultant based in the United Kingdom. He has worked with SQL Server for over 25 years, and now focuses on Power BI. During this time, he has developed several dozen BI and analytics systems based on the Microsoft BI product suite. Adam has been creating JSON theme files since the feature was first introduced in Power BI Desktop, and has delivered corporate Power BI themes for dozens of clients across Europe. 

Adam is a graduate of Oxford University. He has applied his skills for a range of clients in finance, banking, utilities, telecoms, construction, and retail. He is the author of Apress books: SQL Server Data Integration Recipes; Business Intelligence with SQL Server Reporting Services; High Impact Data Visualization in Excel with Power View, 3D Maps, Get and Transform and Power BI; Pro Power BI Desktop; and Data Mashup with Microsoft Excel Using Power Query and M.

Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation