Showing results for 
Search instead for 
Did you mean: 
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

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors