Numerical Ranges

[Aryaja96]

I have a practice dataset which has two tables. one for 2020 and one for 2021, they are just practice survey data for remote work. i am trying to create a visualization where i can show the number of people by an age range like no of people in 20-30,then  30-40 and so on. i have grouped the column and created bins but i am clueless about what i should do next. i was trying to replicate this kind of visualization.   

    this is from someone else's report but i was practicing and wanted to see if i could create this as well. 

can anyone suggest something?         

[Aryaja96]

thank you for the reply, i am going to try it out and let you know if it helps! 🙂

[tackytechtom · Accepted solution]

Hi @Aryaja96 ,

It depends on your data and the model you are using, but if were you heading for something like this, I can show you how I did it 🙂 

I used the following sample data:

YearAgeBin

2020	21	Between 20-30
2020	27	Between 20-30
2020	31	Between 30-40
2020	22	Between 20-30
2020	25	Between 20-30
2020	39	Between 30-40
2020	35	Between 30-40
2020	42	Between 40-50
2020	58	Between 50-60
2021	61	> 60
2021	67	> 60
2021	62	> 60
2021	80	> 60
2021	22	Between 20-30
2021	30	Between 30-40
2021	31	Between 30-40
2021	32	Between 30-40
2021	25	Between 20-30
2021	27	Between 20-30

And then what I did was the following for the left graph:

And for the right graph, I created a separate measure called PercentageMeasure with the following DAX:

PercentageMeasure = 
VAR _overallCountPerYear = CALCULATE ( COUNTROWS ( Table ), ALLEXCEPT (Table, Table[Year] ) )
RETURN
DIVIDE ( COUNTROWS ( Table ), _overallCountPerYear )

The graph had the following settings:

For both graphs I chose the stocked bar chart   

 

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/