Forum Discussion
Anonymous
9 years agoNot applicable
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 :)
- 9 years ago
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.
Greg_Deckler
9 years agoCommunity 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.