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.
Hi
I'm having issues with a SharePoint list and a person field while building a fleet management report. I want to report on Current Drivers Display name field.
If you compare the Current Driver (SharePoint Person column) and Created By (the default sharepoint field) you can expand the default one but not the other.
In Power BI you can drill down and see the values in the data but it is missing the icon to extract the fields into the wider data set.
Am I being thick or is there another way to do it?
Many thanks in advance.
Solved! Go to Solution.
Hi, @n1112997
Select the Current Driver column, use the Replace Values feature, replace the blank with null and try again
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi, @n1112997
Select the Current Driver column, use the Replace Values feature, replace the blank with null and try again
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thank you very much! That had me completely baffled.
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 |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |