cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Aryaja96
Frequent Visitor

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.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?         

1 ACCEPTED SOLUTION
tackytechtom
Super User
Super User

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 🙂 

tomfox_0-1652204602825.png

 

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:

tomfox_1-1652204788907.png

 

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:

tomfox_2-1652204912279.png

 

For both graphs I chose the stocked bar chart   

 

 tomfox_3-1652205008658.png

 

Let me know if this helps 🙂

 

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

 

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

2 REPLIES 2
Aryaja96
Frequent Visitor

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

tackytechtom
Super User
Super User

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 🙂 

tomfox_0-1652204602825.png

 

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:

tomfox_1-1652204788907.png

 

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:

tomfox_2-1652204912279.png

 

For both graphs I chose the stocked bar chart   

 

 tomfox_3-1652205008658.png

 

Let me know if this helps 🙂

 

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

 

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.