Show the highest value

[Harris021]

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 .

[Shravan133 · Accepted solution]

• 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 · Accepted solution]

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

[Shravan133 · Accepted solution]

• 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.