cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors