Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

New Member

Textfield with selected value and text



I am just starting to work with Power BI, and as I expected I have my first problem, where I hope to find a solution here 🙂


I have a table with the following fields:





I created a stacked bar chart and a textfield which shows the value of the selected bar.

For example:

Status = Awarded

Year = 2017

Sales will change to the respective amount.


What I would like to have is something like

Awarded in 2017 is xxx US $ - so in short I want to add the fields.


Any idea how to achieve it in an easy way?


Resident Rockstar
Resident Rockstar

Cool My dear friend,


Try this,




let me know if any help on this




Thats not what I meant


I want to add the following


Awarded for 2017 is US $ xyz


- The word awarded has to be changed based on the selected status

- The year has to be changed on the selected year

- The sales has to be changed


So far only the sales changes, which is the standard functionality of BI.

You can create the following measure and put it in a card visual that changes based on your selection


Text= VALUES(Table1[Status])&" for year "&VALUES(Table1[Year])&" is US $"&VALUES(Table1[Sales])


Make sure to have your Status and Year columns put in a slicer.


Hope this helps.

I managed to do something similar by creating a Measure with the text/data I wanted.  The measure name is 'Title'


Title =
"Data For "
    &       MAX( V_DailyTransactions[AsOfDate])


And then I placed this measure in a Card visualization.

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.