Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
.
Can any one please help me how can I remove "First" word
Solved! Go to Solution.
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:
Hey @Anonymous ,
add the calculated column to the "Rows" with drag and drop. I think that's what you want.
@selimovd @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:
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |