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

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Reply
MichaelBr
New Member

Textfield with selected value and text

Hello

 

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:

Status

Year

Sales

 

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?

Thanks

4 REPLIES 4
Baskar
Resident Rockstar
Resident Rockstar

Cool My dear friend,

 

Try this,

 1.JPG

 

 

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

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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