Skip to main content

Charticulator Expressions

  • Chapter
  • First Online:
Introducing Charticulator for Power BI
  • 1097 Accesses

Abstract

In this chapter, we take a break from designing charts and instead take a detailed look at the expressions used by Charticulator when you bind data to an attribute. You also may have been at a loss as to how Charticulator’s rather unusual numeric formatting method works. This is where you edit characters inside the curly braces. It’s a syntax known as “d3-format.” Have you ever heard of it? No? Well, neither had I nor indeed have any of my more “techie” friends. It doesn’t help that Charticulator’s documentation doesn’t throw much light on how you’re meant to use this syntax (it took me some time to find out how to insert a comma separator). Just to fill you in, “d3-format” is used by JavaScript programmers to format numbers, apparently for “human consumption,” according to GitHub (https://github.com/d3/d3-format), and is based on Python 3’s formatting specifications. However, I don’t suppose knowing this really helps a lot, so in this chapter I will throw some light on this rarefied syntax language. What we will also discover is that there is an alternative approach to formatting numerical fields using DAX, and we will explore this possibility at the end of this chapter.

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

Access this chapter

Subscribe and save

Springer+
from €37.37 /Month
  • Starting from 10 chapters or articles per month
  • Access and download chapters and articles from more than 300k books and 2,500 journals
  • Cancel anytime
View plans

Buy Now

eBook
EUR 17.99
Price includes VAT (Netherlands)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
EUR 65.39
Price includes VAT (Netherlands)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Similar content being viewed by others

Author information

Authors and Affiliations

Authors

Rights and permissions

Reprints and permissions

Copyright information

© 2022 The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature

About this chapter

Check for updates. Verify currency and authenticity via CrossMark

Cite this chapter

Box, A. (2022). Charticulator Expressions. In: Introducing Charticulator for Power BI. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-8076-8_8

Download citation

Publish with us

Policies and ethics