The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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:
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.