Curbal has its own social media server on Mastodon. Check it out here!
Welcome to our Knowledge Base

Tip: Start typing in the input box for immediate search results.

Print

Custom data labels with dynamic formatting in Power BI

In this video I will show you how to add annotations to your charts using dynamic formatting 🙂

Watch the tutorial on YouTube

More Dynamic formatting AWESOMENESS!! | Annotations with dynamic formatting

The code or download sample file:

And here is the code for the formatting:

VAR annotDate = SELECTEDVALUE(Annotâtions[Date]) 

return

SWITCH(TRUE(),
SELECTEDVALUE('Calendar'[Date])= annotDate, 
SELECTEDVALUE(Annotations[Event short]), ‭""""‬)

But if you prefer the file, download it here – Community Downloads -#080

More tips and tricks on formatting data labels:

Show numbers in Thousands or Millions in same column with the new Dynamic formatting in Power BI
DAX Fridays #220: SELECTEDMEASURE function
Was this helpful?

Reader Interactions

Let us know your thoughts...

Table of Contents