Forum Discussion

Aryaja96's avatar
Aryaja96
Frequent Visitor
4 years ago
Solved

Numerical Ranges

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?         

Need Help
  • tackytechtom's avatar
    tackytechtom
    4 years ago

    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

    202021Between 20-30
    202027Between 20-30
    202031Between 30-40
    202022Between 20-30
    202025Between 20-30
    202039Between 30-40
    202035Between 30-40
    202042Between 40-50
    202058Between 50-60
    202161> 60
    202167> 60
    202162> 60
    202180> 60
    202122Between 20-30
    202130Between 30-40
    202131Between 30-40
    202132Between 30-40
    202125Between 20-30
    202127Between 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/

     

     

     

2 Replies

  • tackytechtom's avatar
    tackytechtom
    Most Valuable Professional
    4 years ago

    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

    202021Between 20-30
    202027Between 20-30
    202031Between 30-40
    202022Between 20-30
    202025Between 20-30
    202039Between 30-40
    202035Between 30-40
    202042Between 40-50
    202058Between 50-60
    202161> 60
    202167> 60
    202162> 60
    202180> 60
    202122Between 20-30
    202130Between 30-40
    202131Between 30-40
    202132Between 30-40
    202125Between 20-30
    202127Between 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/

     

     

     

  • Aryaja96's avatar
    Aryaja96
    Frequent Visitor
    4 years ago

    thank you for the reply, i am going to try it out and let you know if it helps! ğŸ™‚