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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.