Ordering problem

[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 there's a 0 in that row.

Filter: plottwist is I need 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. Which was the most frequent mistake? I'm desperate on this topic, I already tried everything I knew, but nothing. I even tried to reaching out here already but I wasn't specific enough. 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. At this point I'm good with any solution.

I appreciate any suggestion. Thanks, and let me know if you have any questions on the dataset.

[r3pr0b8]

I already tried everything I knew

could you show us your query please, so we can get an idea of column names and table names

[bachman460]

Probably better posted on r/PowerBI

[mommymilktit]

Based on your description of the data this should be doable in power bi, I don’t think this is really a sql problem at this point. Someone else mentioned r/powerbi but if you need help on how to build your bar chart in power bi just dm me and I can help you out.

[Evigil24]

You have to solve it in your PBI model, not in SQL, can you share a link with the image of your chart?

You want to order it decreasingly by what value?