Interactive text Box With Condition

[chethan]

Hi Floks,

I Want to creat a Text Box which have to be a interactive when we use filters or Slicers

Example :

In year 2017 (Year Coloum) State Hydrabad (Territory) has Made a sale of 72M (Profit) which is Greather that All the State  & In January (Month Coloum) City Mumbai (City) has 78% (Profit % Coloum) of Profit which is Lesser that All the City

Please help on this 

Thanks in Advance 

Regards,

Chetan K

[v-huizhn-msft · Accepted solution]

Hi @chethan,

As the posted above, you have to create a measure using the similar formula.

text="In year" &measure1&"State"& measure2&"has Made a sale of"& "which is Greather that All the State  & In" measure3&" City Mumbai (City) has" &measure4& "of Profit which is Lesser that All the City"

I test using my sample table, please review the following.

My sample table.



Create a measure using the formula, and display it in card visual. It will changes with the value selected in slicer.

Measure 3 = "This is the max"&MAX('Table#1'[Amount1])

Best Regards,
Angelia

[chethan]

@v-huizhn-msft Super Thanks,

How to formate the to % 

[chethan]

@v-huizhn-msft Super Thanks,

How to formate the to % 

[Salvador]

Hi,

Using concatenate with text & info from measures could work ^^

[chethan]

@Salvador i have tryed but unable to get it can you Share the sample as per the above details

[Salvador]

Hi,

@SqlJason has the solution in this post https://community.powerbi.com/t5/Desktop/Dynamic-Text/td-p/18161