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