Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Dynamic text depending on the selection made

I have these 2 combos on the screen, depending on what I select I need the text of the text box where it puts dynamic text to change.

In the model are related tables by Id_type, here I leave a screenshot.

I hope you can help me, thanks

3 Replies

  • Anand24's avatar
    Anand24
    Super User
    3 years ago

    Hi Syndicate_Admin ,
    Considering whatever is selected in the slicers to be displayed as text seperated by space, try below DAX and take the calculated measure into car viz:
    Slicer Appended Measure = SELECTEDVALUE(Field1) & " " & SELECTEDVALUE(Field2)

     

     

    Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

    Proud To Be a Super User !!!
    LinkedIn
    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      3 years ago

      I explained wrong. In the text box, the issue field of the Types table must appear depending on the combination you make that is in the combinations table. As you can see in the combinations table is the Id_type that is related to the Id_type of the Types table.

      I hope I have explained myself better.

      Thank you

      • Anand24's avatar
        Anand24
        Super User
        3 years ago

        Syndicate_Admin ,
        Please make the relationship such that "Combinations" filters "Types". Hence please change to bi-directional or arrow towards Types.
        Currently the filtering you have set means Types filters Combinations. Hence, filtering is not being done when you have slicers from combinations and want to drive field from Type.

         

        Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

        Proud To Be a Super User !!!
        LinkedIn