Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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?
Solved! Go to 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/
Proud to be a Super User!
thank you for the reply, i am going to try it out and let you know if it helps! 🙂
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/
Proud to be a Super User!
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.