Write, Bureaucrats, Administrators
3,246
edits
Difference between revisions of "How to separate Xero Tracking Categories into distinct columns using Power Query"
How to separate Xero Tracking Categories into distinct columns using Power Query (view source)
Revision as of 23:48, 10 February 2022
, 23:48, 10 February 2022no edit summary
| Line 1: | Line 1: | ||
Rather than having two distinct fields, tracking categories are returned as a table of information, tagged against each line. | |||
When you expand this data, this information is placed in a single column that repeats down the data set. | |||
When displayed within Power BI or Excel, this single column doesn’t lend itself to being charted easily | |||
The solution is to use Custom Columns to pull the tracking categories into distinct fields. Then, you can use these distinct fields within your dashboard and reports. | |||
{{#ev:youtube|CYUA4wA-94s|560|left|How to separate Xero Tracking Categories into distinct columns using Power Query}} | |||
To separate Xero Tracking Categories into distinct columns, follow these steps. | To separate Xero Tracking Categories into distinct columns, follow these steps. | ||