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.
I've put together a Table with data from a pivot table. All columns are summed so I can apply conditional formatting, but the "ID" column is the only column that has "Sum of" in the header. I cannot figure out why it is the only column with it or how to get it to go away. If I change the value type (to Average, Count, etc.) of the other columns, then it adds the "(value type) of" in the column header. Sum is the only selection that doesn't add text to the column header. Something is off.
Solved! Go to Solution.
Have a crack at making your own measures.
So rather than dragging your value across and setting the aggregation type. Create a new measure like
ID = SUM('Table'[Value])
and dragging this measure to your visual.
Have a crack at making your own measures.
So rather than dragging your value across and setting the aggregation type. Create a new measure like
ID = SUM('Table'[Value])
and dragging this measure to your visual.
With this approach, your measure name becomes the column header.
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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |