Forum Discussion
Remove auto appending text for Calculated Column
Hello All,
I had created a calculated column to set some value to it based on other columns,
And when I try to add the calulated Column to Matrix Chart in values Section it's appending the word "First" with Calulcated Column Name as below
Need to Remove Auto Append Work First.
Can any one please help me how can I remove "First" word
Anonymous
Hey Anonymous ,
if the result is good and you just want to remove the word "first" then click with the right mouse button to the field, chose "Rename for this visual" and remove the "First" from the name:
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
4 Replies
You are creating what are called implicit measures where it is taking the first value of that column. If you don't want them aggregated, you need to put those columns in the Rows field well (not Values). Or you can create an explicit measure with an expression (e.g., NewMeasure = MIN(Table[Column]) ) if you do want an aggregation but don't want it to say "First".
Pat
Hey Anonymous ,
add the calculated column to the "Rows" with drag and drop. I think that's what you want.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovicselimovd mahoneypat Thanks for the response , I need to remove the word "First" shown in above image which is auto generating when I drag the Calulated Column from data table to Value Section of Visualization
Hey Anonymous ,
if the result is good and you just want to remove the word "first" then click with the right mouse button to the field, chose "Rename for this visual" and remove the "First" from the name:
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
