Forum Discussion
Values in a table with multiple names
Hello,
I have several reports where the client wants the same field to have different names on the same table.
For example they have a field called "In Transit" and they want it on the same table called "Microsoft In Transit" and also "LP In Transit"
After dragging the field to the Values area and changing the name, I noticed that it willy only use one of the names.
Does anyone know how to fix this issue?
Thanks,
Rochelle
robarbie you have to replicate that measure or column and then drop it in the values sections, you cannot have the same measure on the value section and rename it to different names.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
5 Replies
robarbie you have to replicate that measure or column and then drop it in the values sections, you cannot have the same measure on the value section and rename it to different names.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Hi,
I am not using a measure. What do you mean by replicating the column?
robarbie you can duplicate the column using following:
New Column1 = YOurTable[YourColumn] New Column2 = YourTable[YourColumn]You can name these new columns whatever you want.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
That wouldnt work for me. the table name would not generate.
robarbie no idea what you mean? Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
