View Usage Metric

[CCUK22]

Hello Community,

I was wondering if it is possible to display the names of unique users instead of their email addresses in the 'New Usage Metric Report'. As you can see in the picture, only email addresses are currently being shown.

Thank you

[v-yueyunzh-msft · Accepted solution]

Hi, @CCUK22 

Depending on your description, you want to display name instead of email in Usage Metrics.

There are two ways to customize the Usage Metric, the first is Save a copy; The second is that Desktop uses live connection to connect to the dataset.

The first method:

For the first way, we can see that there is no name field in the User table:

So we can use Desktop to connect to the dataset, and then create a measure to remove the email suffix:

Measure = LEFT(MAX('Users'[UniqueUser]), FIND("@",MAX('Users'[UniqueUser]))-1)

The result is as follows:

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly