Forum Discussion
Formula to sort by accuracy (absolute error)
Hello everyone, I need some help. Any advice will be appreciated, especially if someone can explain. I have such a visualization. I need to sort by lowest forecast accuracy. ...
Anonymous Why not something using absolute value? Like:
Error = ABS([Accuracy] - 1)
Anonymous assuming that you don't want the absolute error to be shown in the visual, the only way I'm aware of with a table/matrix visual is described in the 2nd part of the article below. Basically involves creating a measure for sorting, adding to the visual, and adjusting the column width such that the column is no longer visible.
https://pbivisuals.com/2021/03/03/power-bi-sorting-data-by-a-column-not-shown-in-visual/