Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi Folks,
I need HELP. How can I create a dynamic textbox, I need to add variables (similar to the pic above)?
Thanks 🙂
Solved! Go to Solution.
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.
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.
| User | Count |
|---|---|
| 54 | |
| 37 | |
| 27 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 69 | |
| 57 | |
| 38 | |
| 21 | |
| 21 |