Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Histogram column labelling

I have suceeded creating this histogram, my only problem is bin labeling on x-axis. It works fine I define it as number, however, it does not reflect the logic: my bin is a range, not a single number.

 

However, if I label the bins how I want it, then it can only be text, and the columns get sorted in a weird way:

 

There are different sorting options available, but I can't completely unselect sorting. I would like to have predefined column order, so that they don't switch whichever way they please. Is it possible? Maybe it is possible to define it in DAX? My measure for bins: 

 

Case = VAR CatVar=[Distance] RETURN CALCULATE (VALUES ( Benchmark[Category]), CatVar>=BenchMark[Lower_Level],CatVar<Benchmark[Upper_level])

 

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago
    I would like to have predefined column order, so that they don't switch whichever way they please.

    Then it will no longer be a histogram

     

    You can force a sort order by maintaing a separate sort column and then sorting your bucket column by that.