Creating a Histogram Decile Chart

[Saes]

Hi all, I'm trying to create a histogram that shows the count of properties by decile group. The raw data I have looks like this:

Property ID	Rent	Local Comparator
Property 1	£82.50	£100.00
Property 2	£90.00	£100.00
Property 3	£117.50	£100.00
Property 4	£98.50	£100.00
Property 5	£126.50	£100.00

I have a measure that divides the rent by the local comparator and, using the Ceiling function, rounds the result upwards to the next decile - for example:

Property ID	Rent	Local Comparator	Decile
Property 1	£82.50	£100.00	90%
Property 2	£90.00	£100.00	90%
Property 3	£117.50	£100.00	120%
Property 4	£98.50	£100.00	100%
Property 5	£126.50	£100.00	130%

When I put the information into a graph, the results look like this:


I would like the bars to show the count of properties by decile group, but cannot figure how to do this. Can anyone help?

[Anonymous]

Hi @Saes ,

Try to use stacked column chart and it works fine

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mahoneypat]

Did you select the 100% Stacked Chart (Y axis has % values)?  If so, change it to a regular stacked or clustered chart.

Pat

[Saes]

Hi Pat, the example shows a regular chart.

[amitchandak]

@Saes , Decile is a new column?

like this  ?

roundup(divide([Rent],[Local Comparator]),-1)

[Saes]

Hi @amitchandak , the decile calculations is a measure, not a column. I wanted to try to avoid using a column, as I need to build other comparators later which would add many columns to the model.