Write, Bureaucrats, Administrators
3,246
edits
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. | ||