Write
280
edits
Difference between revisions of "Display missing data/fields in Microsoft Excel and Microsoft Power BI"
Display missing data/fields in Microsoft Excel and Microsoft Power BI (view source)
Revision as of 00:12, 18 July 2024
, 18 Julyno edit summary
m (added break point in related links) |
|||
| Line 19: | Line 19: | ||
# Nested columns will be displayed with an '''Expand''' button beside the column name. | # Nested columns will be displayed with an '''Expand''' button beside the column name. | ||
# Upon clicking the '''Expand''' button, all the nested fields will be displayed as a list. Select the columns you want by clicking on the check box beside the field names. | # Upon clicking the '''Expand''' button, all the nested fields will be displayed as a list. Select the columns you want by clicking on the check box beside the field names. | ||
# Once you've expanded all the required columns, click on '''Close & Load | # Once you've expanded all the required columns, click on '''Close & Load''' button in the '''Home''' Menu | ||
Once completed, you will be able to view the nested columns in your report. | Once completed, you will be able to view the nested columns in your report. | ||