Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
After creating a new column with UNICHAR(11044), the word 'first' is automatically added to its column name in the fact table. Any help will be appreciated.
Solved! Go to Solution.
Hey @Anonymous ,
this is because you added the column "signal" to the Values band of the Matrix visual:
As the column is of non-numeric data type the aggregation function is used "First".
Maybe you want to place the column on the Columns band?
Hopefully this provides some additional insights.
Regards,
Tom
@Anonymous can you share your screen shot what you mean? Sorry not fully clear what you are asking here.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@parry2k Thank you for your help. As shown in the screen shots, I created a column entitled "signal" with unichar(), then added the column to the matrix table. Then all of sudden the word 'First' was added to the label.
Hey @Anonymous ,
this is because you added the column "signal" to the Values band of the Matrix visual:
As the column is of non-numeric data type the aggregation function is used "First".
Maybe you want to place the column on the Columns band?
Hopefully this provides some additional insights.
Regards,
Tom
@TomMartens thank you for your reply. I've now realized why the word 'first' was added.
But the values band is the right place because the unicode character in the column changes its color to signal each row's performance.
Hey @Anonymous ,
this makes perfect sense, you just have to be aware that a non-numeric column used on the value band has to be aggregated as this is the "faith" of columns (numeric/non-numeric) used on the value band.
Just simply rename the column, so that it no longer shows the name of the aggregation function in front.
You might also consider to create a measure instead of a column.
Regards,
Tom
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
123 | |
78 | |
49 | |
38 | |
37 |
User | Count |
---|---|
196 | |
80 | |
70 | |
51 | |
42 |