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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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