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)
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 46 | |
| 34 | |
| 27 | |
| 15 | |
| 15 |
| User | Count |
|---|---|
| 59 | |
| 58 | |
| 39 | |
| 22 | |
| 20 |