Forum Discussion
Dynamic text box
Hi Folks,
I have 03 Tables , Table(Divison), Table(Sub Divison), Table(Payments). I am using a pie chart, where Total payment coming from Table(Payments), & I am drilling it down from Divison (Table(Divison)) to Sub Divison (Table(Sub Divison))
Now, my requirement is - If I select something on my pie chart , it gives me some value (eg. Division A, Total payment X)
I want to show the same result (eg. Division A, Total payment X) to be shown in a text box & that text box should give me the selected value every time.
Thanks,
Ashraf
Anonymous ,
Textbox doesn't have that dynamic feature as of now. Instead of text box you can use 3 Card visuals and place your drill down infomation on each card visual. (Refer screen shot below)
Don't forget to give thumbs up 👍and accept this as a solution if it helped you.
7 Replies
Anonymous ,
Textbox doesn't have that dynamic feature as of now. Instead of text box you can use 3 Card visuals and place your drill down infomation on each card visual. (Refer screen shot below)
Don't forget to give thumbs up 👍and accept this as a solution if it helped you.
Anonymous ,
I understood. Please take individual card to show different details. As i have shown in below screen shot when I click on 13-Nov so its respective details are showing in individual Cards.
Don't forget to give thumbs up 👍and accept this as a solution if it helped you.
Tahreem24 Your solution seems very relative to me, but what measure should i give in my card
I do not know your data model, but say the selected value is 'payments'[sometext] (the text belonging to the value)
you might want to try:
selected value = selectedvalue( 'payments'[sometext], "multiple selections, please select one payment")
use the card visual, disable showing the category, and make it display a measure.
That measure should use the 'selectedvalue' method DAX provides.
Hi Anonymous,
I'd like to suggest you take a look at following blogs about getting value from slicer:
Using the SELECTEDVALUE function in DAX
Using SELECTEDVALUES To Capture Power BI Slicer Selections
Regards,
Xiaoxin Sheng
