Help with weight break list

[GilesWalker]

Hi everyone,

I have a column graph which contains gross mass on the Y-axis and months on the X-axis. What I am trying to do is have each bar show through colouring splitting how many tonnes are within different weight brackets. These are the different weight brackets:

Gross mass weight break

<=14

<=15

<=16

<=17

<=18

<=19

<=20

<=21

<=22

<=23

<=24

<=25

<=26

<=27

<=28

<=29

<=30

Normally I would just use an if function however there are 17 different weight brackets. Is there a more efficient way to do this within Power BI?

Thanks,

[ALeef]

Are your weights in tonnes now?  IE, 13.52, 18.01 etc..., you might be able to use RoundDown since all of your buckets are a single tonne wide.  If you want to break it up by more than a single tonne, like 13-16, 17-20 etc... you could find an equation using MOD to determine remainder of a division problem.

You'd probably need to create a measure filterable by month, using a count of each bucket, then drag the month into Axis of a clustered bar chart.

EDIT:  You could also use a stacked bar, I suppose, though I think the clustered might give you more readable results.  

[itchyeyeballs · Accepted solution]

How about something like this? - http://www.powerpivotpro.com/2014/11/new-twist-for-dynamic-segmentation-variable-grain-range-selecti...

[GilesWalker]

Thanks @itchyeyeballs I will check out the page, it seems to be what I am needing.