This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreDid you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now
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)
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 34 | |
| 31 | |
| 30 | |
| 21 | |
| 16 |
| User | Count |
|---|---|
| 65 | |
| 53 | |
| 31 | |
| 23 | |
| 23 |