Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

why the word first is added automatically to my new column name

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.

1 ACCEPTED SOLUTION

Hey @Anonymous ,

 

this is because you added the column "signal" to the Values band of the Matrix visual:

image.png

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

View solution in original post

5 REPLIES 5
parry2k
Super User
Super User

@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.

Anonymous
Not applicable

Power BI Desktop 12_27_2019 2_56_02 PM (3)_LI.jpgPower BI Desktop 12_27_2019 2_56_02 PM (2)_LI.jpg

 

@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:

image.png

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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
Anonymous
Not applicable

@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



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

AugPowerBI_Carousel

Power BI Monthly Update - August 2024

Check out the August 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.