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.

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