Forum Discussion
Wrtting text based on chart values
Hi Anonymous,
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
Microsoft EmployeeHi Anonymous,
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
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!
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!