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,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

 

 

 

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.

4 Replies

  • mahoneypat's avatar
    mahoneypat
    Icon for Microsoft Employee rankMicrosoft Employee
    5 years ago

    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'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

  • v-alq-msft's avatar
    v-alq-msft
    Icon for Community Support rankCommunity Support
    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.