The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the August 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
82 | |
77 | |
48 | |
39 |
User | Count |
---|---|
150 | |
117 | |
67 | |
64 | |
56 |