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.
Hi Folks
any ideas on this- I dont get the option to replace values, but wnat to replace the nulls
Solved! Go to Solution.
I think you can expand that 'List' or 'Record' by clicking the two arrows and it will offer you the option to expand as new rows or to fill the cell with the values. In the case of your null values, you can use a Replace Values transformation and replace 'null' with something else. You're best bet is to go upstream to the source and force a value to be selected in the Person Field. That is, if you have that option available.
I think you can expand that 'List' or 'Record' by clicking the two arrows and it will offer you the option to expand as new rows or to fill the cell with the values. In the case of your null values, you can use a Replace Values transformation and replace 'null' with something else. You're best bet is to go upstream to the source and force a value to be selected in the Person Field. That is, if you have that option available.
Hi @gemcityzach - thanks- sorted.
I expanded the records be selecting the two arrows and selected the values I wanted to expand into new columns and now the option to replace values comes up. All sorted.
I didnt have the option to do at source as it's a person based column so won;t let you add a value that isn't in my organisations GAL (Global Address List)
Thanks @3CloudThomas for your help
Go to Tranform, right-click on the null value in the column and select Replace from the menu
Here is another question like this one:
Solved: Replace NULL - Microsoft Fabric Community
Hi @3CloudThomas - I dont get this, my assumtion as its a person based column.
Right click on a cell only brings up Copy/ Drill Down & add as new query (as mentioned. right clicking the column doesnt bring up the option against the whole column).
The Person columns from SharePoint as a source have been transformed already to extract to individual Record, with any records that didnt have an entry in source coming through as null in PBI.
Sorry, I did not see that that column is of Record type, gemcityzach is correct. You have to click the double arrow in the upper right of the column, and exp...
Hey- no worries @3CloudThomas - all sorted now and I know you would have been on it 🙂
User | Count |
---|---|
89 | |
85 | |
66 | |
62 | |
57 |
User | Count |
---|---|
138 | |
112 | |
94 | |
82 | |
71 |