Dynamic text box

[Anonymous]

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]

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

[jessegorter]

use the card visual, disable showing the category, and make it display a measure.

That measure should use the 'selectedvalue' method DAX provides.

[Tahreem24]

@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.

[Anonymous]

@Tahreem24  Your solution seems very relative to me, but what measure should i give in my card

[jessegorter]

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")

[Tahreem24 · Accepted solution]

@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]

Not necessarily text box, i can use card also. But i want to show the selected result to be shown in that card or box only