Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have a column that is entirely text (aisle locations). I am creating a multi-row card, but I am having an issue presenting the text like I desire. When the aisle field is set to don't summarize, this is how it appears, AD is the aisle.
When I change the aisle field to count, this is how it appears. Below is my desired outcome, but I want the actual text to be displayed, not a count. How do I achieve this?
I tried to play around with DAX formulas, but I am new to them so I am unsure how to proceed. Thanks!!
@DeltaJuliet , You can use MAX, inplace of count. But if there more than one values, then you need same field as "not summarized" and MAX(which I do not think you want)
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 37 | |
| 33 | |
| 29 | |
| 26 |
| User | Count |
|---|---|
| 134 | |
| 104 | |
| 63 | |
| 60 | |
| 55 |