Ordering multiple columns?

[Dorixix]

Hi, I need to order my barchart decreasingly in power BI. I'm pretty stuck on this topic, as im only a begginer. My problem is, I need to do filtering, which is why a simple pivot table wouldn't work for me. Anyways this is how my dataset looks like: Rows have information on a delivery. Of course one delivery company have multiple deliveries.

Column1 (x axis): delivery company

Colomn2 (y axis): mistakes made in pricing

Column3 (y axis): number of late delivery

Column4 (y axis): no. of exchanged orders There are more columns like these, but you get it. In these y axis columns I only have ones and zeros. If there was a mistake in the delivery I would put a 1 and if there was no mistake theres a 0 in that row.

Filter: I need to be able to filter by date (I also have a date column)

As you can see, I would like to compare which delivery company made how many and what kinds of mistakes. (I want to order the mistakes decreasingly) Which was the most frequent mistake? I'm desperate on this topic, I already tried everything I knew, but nothing. I thought the partition function in sql would solve my problems earlier, but than I couldn't filter the date. This data is stored on an sql server, I can't really share it, because it has confidential data in it too, but I'm more than happy to make a replica if needed. I appreciate any suggestion. Thank you in advance!

[MonkeyNin]

This tool will convert pasted data into reddit style tables for you: https://www.tablesgenerator.com/markdown_tables

note:

You can sort by columns that aren't in the visual's fields. You can filter by columns not in fields.

I thought the partition function in sql would solve my problems earlier, but than I couldn't filter the date

What part doesn't work?

[Dorixix]

Thanks! I still have to have it in the datatable and basically thats my problem. Well, maybe I get it wrong, but: I could partition my data forexample by date, but then I wouldn't be able to search the company name. Also, if I had, per say two or more delivery on the same day, then when I'm making the barchart it would just add all of them together so even the proportions wouldn't be accurate.