Forum Discussion

matout's avatar
matout
Icon for Helper I rankHelper I
5 years ago
Solved

Values arrangement in visual

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...
Need Help
  • v-alq-msft's avatar
    v-alq-msft
    5 years ago

    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.

matout's avatar
matout
Icon for Helper I rankHelper I
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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