Bar chart where one category must always be first

[RingoSun]

Basically I want the blue bar called sample to always be the first one in my bar chart no matter what the values are. Is something like this possible in Power BI? 

[SpartaBI]

@RingoSun create a sort by column with the same granularity of that column that you put in the visual. In the sort by column put 1 to sample and whatever logic you want for the others. Then in the settings of the original column make it sort by the new column you created.

In the visual make sure you sort the axis by the original column and not the value. It will give you the desired result.

In case it answered your question please mark this as a solution for community visibility. Appreciate Your Kudos 🙂 

[selimovd · Accepted solution]

Hey @RingoSun ,

you can do that with a sort by colum.

There you can say the category "Sample" is always 1. You can define the rest, but don't have to as far as I remember. Check the following article for more information:

https://docs.microsoft.com/power-bi/create-reports/desktop-sort-by-column

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards
Denis

Blog: WhatTheFact.bi
Follow me: twitter.com/DenSelimovic

[RingoSun]

@selimovd 

Hello thanks for the reply! But I cant seem to see where I'm supposed to set the category "Sample" as 1

Edit: Nvm I figured it out, it can be done in Power Query