Values arrangement in visual

[matout]

Hello, 

I am relativly new to powerBI and I have the following problem.

I have this 100% stacked visual, all of these values are derived from a columne in a table that has 3 possible values 1,2,3.

I want to make value 1 and 3 be next to each other and the rest is value 2.

For example, in this visual we have red bar sandwiched between the other colors, 

I want to make other the red bar, with its values be on top, and the rest is by other bars.

Can I obtain this in PowerBI

thank you

[v-alq-msft · Accepted solution]

Hi, @matout 

You may try what is suggested by @Anonymous . I created data to reproduce your scenario. The pbix file is attached in the end,

Table:

Category:

There is a relationship between two tables. Then you may make 'Category' sorted by 'Value' descending.

Best Regards

Allan

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

[mahoneypat]

This is possible.  In the query editor, you can highlight that column and choose Replace Values to change the 2 category to "Other", then load the data.  Depending on what the category 1 and 3 are, you may need to add a Sort By Column to get Other to show up last.  

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

One you do that, you can edit the Data Colors on the visual to make Other red.

Regards,

Pat

[matout]

what I want is the following.

I have a column with 3 possible values (Yes, No, N/A)

in a 100% stacked bar chart

the bars are arranged (from top to bottom)

Yes

N/A

No

I want to change that arrangement

I want the bars arrangement to be Yes, No, N/A

is that obtainable?

I don't want to sort, I want to rearrange the position of the values in bars

[Anonymous]

Hi @matout  not possible directly to order the customise ordering of clustered bar chart, but what you can try is have another table (Add Data) with static data

Yes   1

No    2

N/A   3

Connect this table to your main table on Yes/No/NA value and sort using this new columns (using Tooltip)

Hope this helps.

Cheers,

-Namish B