Create Dual Chart

Question

Hi all,&nbsp;I have a rawdata file extracted from SQL. I would like to use DAX to create proportion by row for each Class from each school. there are over 200 schools over 5 year period.&nbsp; (I know this can be done easily in excel)&nbsp;Each Dual chart will contain number of students in Class A and proportion out of each class at rolling 5 year period.&nbsp;&nbsp;After that, I would need to create a cohort based on school characteristics. The proportion do not need to be changed. Any suggestion.&nbsp;&nbsp;&nbsp;See sample below.Year&nbsp; &nbsp; School&nbsp; Total students&nbsp; Class A&nbsp; Class B&nbsp; Class C&nbsp; 2019&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;A&nbsp; &nbsp; &nbsp; &nbsp; 200&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;100&nbsp; &nbsp; &nbsp; &nbsp; 20&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;50&nbsp;&nbsp;2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;B&nbsp; &nbsp; &nbsp; &nbsp; 100&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 35&nbsp; &nbsp; &nbsp; &nbsp;25&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;40

lbendlin · Answer

Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

Forum Discussion

Create Dual Chart

1 Reply

Related content

Dual Sorting for Stacked Bar Chart

Dual Y axis overlapping column chart

Dual Storage mode

Creating a Control Chart

Dual Axis Chart with Geo Map.