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.
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?
Solved! Go to 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
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
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?
User | Count |
---|---|
82 | |
77 | |
62 | |
60 | |
49 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |