Forum Discussion

MichaelBr's avatar
MichaelBr
New Member
9 years ago

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

  • Baskar's avatar
    Baskar
    Resident Rockstar
    9 years ago

    Cool My dear friend,

     

    Try this,

     

     

     

    let me know if any help on this

     

     

     

    • MichaelBr's avatar
      MichaelBr
      New Member
      9 years ago

      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.

      • shjaffer's avatar
        shjaffer
        Frequent Visitor
        9 years ago

        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.