Forum Discussion
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.
- Create a calculated column in your table that assigns a numeric order to your True/False values:
- Anonymous1 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
- Shravan133Super User
- 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.
- Create a calculated column in your table that assigns a numeric order to your True/False values:
- AnonymousNot 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