Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
i want to remove that average that comes before the legend, is there a way to do it ?
Solved! Go to Solution.
go to power query editor
right click on column you're using for the legend and "Replace Values"
then do this for each of the items in your legend column. You can rename them as you want then. Hope this helps!
go to power query editor
right click on column you're using for the legend and "Replace Values"
then do this for each of the items in your legend column. You can rename them as you want then. Hope this helps!
I think you could also do this
Just put a space in the second box 🙂
Can't you replace the average in Power query editor?
Thanks,
Arul
no because it would just switch from average to sum for an example, what i want to do is remove that words that always come before what i want people to see on the legends.
I assume that is aggregation name comes along column name every time depends on the aggregation you change. If that is the case you can change the name in the fields by double clicking column names in the highlighting area, Please refer the below,
Before name change:
After change:
Thanks,
Arul
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 40 | |
| 37 | |
| 35 | |
| 34 | |
| 28 |
| User | Count |
|---|---|
| 136 | |
| 99 | |
| 73 | |
| 66 | |
| 65 |