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.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 38 | |
| 38 | |
| 31 | |
| 22 | |
| 15 |
| User | Count |
|---|---|
| 74 | |
| 61 | |
| 31 | |
| 31 | |
| 23 |