DAX Formula for Multi-Line Titles in Chiclets

Objective

The goal is to create a DAX formula that concatenates two rows into a multi-line title for use in Chiclets in Power BI.

Provided Formula

The initial formula you provided is:

Chicklets Name = ‘Due Dates’[Training Title] & UNICHAR(10) & ‘Due Dates’[Due Dates]

Updated DAX Formula

To ensure clarity and functionality, I recommend the following improved version of the DAX formula:

Chicklets Name = 
    CONCATENATE(
        SELECTEDVALUE('Due Dates'[Training Title]), 
        UNICHAR(10) & SELECTEDVALUE('Due Dates'[Due Dates])
    )

Explanation

1. SELECTEDVALUE: This function retrieves the value of a single-column field (in this case, 'Due Dates'[Training Title] and 'Due Dates'[Due Dates]). If there are multiple values, it returns a blank. This helps ensure that undefined values don't cause issues within the concatenation.

2. CONCATENATE: This function is used to join two strings together. It concatenates the selected training title with a new line (using UNICHAR(10)) and the due date.

3. UNICHAR(10): This function represents line feed (newline) in Power BI, allowing text to break onto the next line in the format used in the Chiclet visual.

Application

• Chiclets Visual: When this formula is applied within the Chiclets visual in Power BI, it will display the training title on the first line, followed by the due date on the second line. This format makes the title more readable and organized.

Practical Example

Consider the following data structure in the table 'Due Dates':

Applying the formula will result in the following titles in the Chiclets:

1. "Data Science Basics"
   "2023-12-01"

2. "Advanced DAX"
   "2023-12-15"

The end result will be two-line entries for each Chiclet, ensuring that information is easily accessible and visually appealing.

Conclusion

This formula serves the purpose of creating a clean and concise multi-line representation in your Chiclet titles in Power BI. For further enhancement of your DAX skills, consider exploring the Enterprise DNA Platform.