Wrtting text based on chart values

[harshadsp]

Hello All,

Could you please advise is there any way I can write a text lines based on analytics from bar chart? Say, I have following bar chart in 1st 'Tab' page in PBI desktop -

Then I would like to write a text on 2nd 'Tab' page like "The max crimes (278) are recorded on Thursday and min crimes (220) are recoreded on Wednesday"

I guess I would need to use a card visual to embed the values in between the hardcoded texts but not sure how that would flow from tab 1 (where actaul graph is plotted) to tab 2 (where I need to write those lines).

Please advise.

Thanks!

[v-huizhn-msft · Accepted solution]

Hi @harshadsp,

Actually, I am confusing about your requirement: how that would flow from tab 1 (where actaul graph is plotted) to tab 2 (where I need to write those lines)?

For add a text line, you can create two measure to get the max/min value. I name the measure name to get max value as max_value, the measure name to get min value as min_value, then you can create another measure using the formula below to display it in card visual.

text="The max crimes"&&[max_value]&&"are recorded on Thursday and min crimes"&&[min_value]&&"are recoreded on Wednesday"

Please share more details for further analysis.

Best Regards,
Angelia

[harshadsp]

Hi @v-huizhn-msft

The 'text' formula worked for me, thank you! The only thing is that I need to have the card visual and bar chart visual on same page. I was looking that the bar chart and crad visual with this 'text' on different pages. 

But this works ultimately.

Thanks!

[harshadsp]

Thanks @v-huizhn-msft

Sorry for confusion. The requrement is like-

Assume I have one tab1 where I have the bar chart and I need to create another tab2 where I can write the text based on values of of chart in tab1. So I have doubt that how would I capture the values in tab1 chart and write those in tab2 text lines.

I will try as per you have mentioned.

Thanks for your inputs!