Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! 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)
| User | Count |
|---|---|
| 55 | |
| 37 | |
| 26 | |
| 17 | |
| 17 |
| User | Count |
|---|---|
| 69 | |
| 58 | |
| 39 | |
| 21 | |
| 21 |