Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I remembered I can drop a column to values in a matrix, and Power BI will automatically summarize it like by sum, the first, the last... However, I find I cannot do this again. When I drop a column defined as text in a matrix, nothing happens. I don't want to write a measure to get the first value.
Am I missing something? Or we don't have the function now?
Solved! Go to Solution.
Hi @Ayna
Do you mean the aggregation types for text type fields in Values of a matrix visual? They are still there. It will select "First" for a text type column by default.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Hi @Ayna
Do you mean the aggregation types for text type fields in Values of a matrix visual? They are still there. It will select "First" for a text type column by default.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Thanks for your reply. I tried in my other reports, and I still can aggregate text type in a matrix visual. But, cannot do it in my ongoing report.
Hi @Ayna
A column that is Text does not work the same way as a Value. Functions such as "count" or "sort" and others can be done with text, however, given text is not a value, you can't use it as such.
What is your Text column made up of? Is it numbers that are in text format?
Thanks,
Theo
If I have posted a response that resolves your question, please accept it as a solution to formally close the post.
Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!
Want to connect?www.linkedin.com/in/theoconias
User | Count |
---|---|
93 | |
83 | |
77 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |