Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
52 | |
35 | |
32 | |
31 | |
25 |