Best way to roll up data?

[Drew_Johnson]

I have a dataset with sales Invoices and related sales tax. For each sales invoice there could be a combination of city/county/state tax amounts. I've created a visual to summarize the data and noticed that I have multiple lines (see below):

I would prefer to have each sales invoice have a single line with the city, state, and county tax shown. Is there a way to accomplish this? 

[v-yanjiang-msft · Accepted solution]

Hi @Drew_Johnson ,

According to your description, you want to show the name of tax(city tax/state tax) in one column and the value in another column. If so, go to Power Query, select the two columns at the same time and click "Unpivot Columns".

Result:

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

Best regards,

Community Support Team_yanjiang

[Drew_Johnson]

Here is a better look at our source data from our accounting system: 

In this specific $129.98 sales transaction there were three separate tax amounts assessed:

City (BUFFALO $1.95)

County (LEON $.65)

State (TX $8.12). 

I would like to roll this up to a single line and have a separate column showing each tax amount in the visual. Any best practices to accomplish this?