Forum Discussion
Color a specific string inside a measure for use in a Textbox
- 1 year ago
mcijerry Add a text box to your Power BI report where you want to display the message.
In the text box, insert the measure you created. This will display the full message including the username.
Since DAX does not support text formatting, you will need to use Power BI's conditional formatting to color the username. Unfortunately, Power BI does not support conditional formatting within text boxes directly. However, you can use a workaround by creating a separate measure for the username and then using a card visual to display and format it.
Create a new measure for the username:
Username Only = USERNAME()
Add a card visual to your report and set its value to the Username Only measure.
Use the formatting options in the card visual to set the text color to blue.
Position the card visual with the username next to the text box so that it appears as part of the same sentence. This way, the username will be displayed in blue while the rest of the text remains in the default color