Forum Discussion

mcijerry's avatar
mcijerry
New Member
1 year ago
Solved

Color a specific string inside a measure for use in a Textbox

Using the measure below to dynamically reflect the logon user in a textbox.  I would also like to color only the USERNAME() value returned BLUE Any thoughts? Measure Get Username in Title = ...
  • bhanu_gautam's avatar
    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