Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Dynamic Textbox

Hi Folks,

 

I need HELP. How can I create a dynamic textbox, I need to add variables (similar to the pic above)?

 

Thanks :)

  • Use a multi-row card visualization and measures like this:

     

    Measure = IF(HASONEVALUE(DISTRICT[DISTRICT NAME]),VALUES(DISTRICT[DISTRICT NAME]),"")

    This displays nothing if there is more than one value but otherwise displays the information. You would have multiple measurs like this and add them all to the multi-row card visualization. If you look up my Data Stories Gallery, Ohio Schools Report Card, you will find an example PBIX file that implements this.

     

1 Reply

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Use a multi-row card visualization and measures like this:

     

    Measure = IF(HASONEVALUE(DISTRICT[DISTRICT NAME]),VALUES(DISTRICT[DISTRICT NAME]),"")

    This displays nothing if there is more than one value but otherwise displays the information. You would have multiple measurs like this and add them all to the multi-row card visualization. If you look up my Data Stories Gallery, Ohio Schools Report Card, you will find an example PBIX file that implements this.