Forum Discussion
Show the highest value
- 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:
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
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