Forum Discussion

Harris021's avatar
Harris021
Frequent Visitor
1 year ago
Solved

Show the highest value

Hi all,

 

I am super new to Power BI and want someone to help me.
How can I always show the True value at the top? It seems that Power BI always puts the highest number at the top.

 

In the below example I want the True value be on the top at all the time?

 

 

 

Kind regards .

  •  

    • Create a calculated column in your table that assigns a numeric order to your True/False values:
       SortOrder = IF([YourBooleanColumn], 1, 2)
       
      Sort your column by this new column:
      • Go to Data View.
      • Select the Boolean column.
      • Click Sort by Column and choose SortOrder.
      • Now, in your bar chart, the True values should always be on top

    Or try sorting using the true/false column:

    Click the ellipsis (⋮) in the top-right corner of the visual and adjust the sorting.

  • Anonymous's avatar
    Anonymous
    1 year ago

    Thanks for the reply from Shravan133 , please allow me to add some more information:

    Hi  Harris021 ,

     

    Here are the steps you can follow:

    If you select Sort by Column and get a circular dependency error message, you can create a new table with de-duplication, join the original table to the new table, and use Sort by Column again to place the new table's columns into visual.

    1. Create calculated table.

    Table 2 =
    SUMMARIZE(
        'Table',[Group2],[Index])

    2. Connecting two tables.

    3. Result:

    Best Regards,

    Liu Yang

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

2 Replies

  •  

    • Create a calculated column in your table that assigns a numeric order to your True/False values:
       SortOrder = IF([YourBooleanColumn], 1, 2)
       
      Sort your column by this new column:
      • Go to Data View.
      • Select the Boolean column.
      • Click Sort by Column and choose SortOrder.
      • Now, in your bar chart, the True values should always be on top

    Or try sorting using the true/false column:

    Click the ellipsis (⋮) in the top-right corner of the visual and adjust the sorting.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Thanks for the reply from Shravan133 , please allow me to add some more information:

    Hi  Harris021 ,

     

    Here are the steps you can follow:

    If you select Sort by Column and get a circular dependency error message, you can create a new table with de-duplication, join the original table to the new table, and use Sort by Column again to place the new table's columns into visual.

    1. Create calculated table.

    Table 2 =
    SUMMARIZE(
        'Table',[Group2],[Index])

    2. Connecting two tables.

    3. Result:

    Best Regards,

    Liu Yang

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