Custom Bin Labels

[Anonymous]

I'm using Groups to cluster my data in bins. I'd like to label the bins by the intervals they represent. My bin size is 30, so I'd like my graphs to have labels like the following:

0-29

30-59

60-89

90-119

120-149

150-170

180-210

Instead my labels are 0, 30, 60, 90,120, 150, and 180.

Is there a way to customize those labels, or a better way to make my graphs that use bins more visually intuitive?

[v-yuezhe-msft · Accepted solution]

@Anonymous,

There is no built-in option to customize the bin labels. In your scenario, you can add a column using the DAX below, then drag the column into your graph.

Column = IF(Table[columnname (bins)]=0,"0-30", if(Table[columnname (bins)]=30,"30-90",IF(Table[columnname (bins)]=90,"90-990",IF(Table[columnname (bins)]=990,"above 990",IF(Table[columnname (bins)]=120,"120-149", IF(Table[columnname (bins)]=150,"150-170", IF(Table[columnname (bins)],"180-210")))))))

Regards,
Lydia

[bkrahulec · Accepted solution]

@Anonymous,

I would use SWITCH() function instead of nested IFs as follows:

NewBinName = SWITCH(
                         [YourBinName]=0,"0-29"
                         ,[YourBinName]=30,"30-59"
                         ...
                         ,[YourBinName]=180,"180-210"
                         ,"Unknown")

However, you don't need to cluster your variable by in-built functionality into category first, when you have to rename it anyway. You can create new column with the category using the SWITCH() function by yourself as follows:

NewCategory = SWITCH(
                         TRUE(),
                         [BaseVariableName]<30,"0-29"
                         ,[BaseVariableName]<60,"30-59"
                         ...
                         ,[BaseVariableName]<211,"180-210"
                         ,"")

The SWITCH() function prioritizes the conditions according to their order.

[RookieAnalyst]

Hi, 

Do you know whether there is any way to do this and leave the bins unsorted, i.e. that they don't order by size? 
I am looking at data for when actions are performed relative to their due dates, and  want bins grouped as '1 day overdue', '2-4 days overdue', '5-7 days overdue' etc.

I haven't been able to sort these according to days in any sensible matter. Do you, or anyone else here know how/if I can do this? 🙂 

[v-yuezhe-msft · Accepted solution]

@Anonymous,

There is no built-in option to customize the bin labels. In your scenario, you can add a column using the DAX below, then drag the column into your graph.

Column = IF(Table[columnname (bins)]=0,"0-30", if(Table[columnname (bins)]=30,"30-90",IF(Table[columnname (bins)]=90,"90-990",IF(Table[columnname (bins)]=990,"above 990",IF(Table[columnname (bins)]=120,"120-149", IF(Table[columnname (bins)]=150,"150-170", IF(Table[columnname (bins)],"180-210")))))))

Regards,
Lydia