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