Forum Discussion
Horizontal bar charts
Hi everyone, I have created the table shown below that shows the % of positive answers by students for each school. I have used the following calculation in my table: Positive response perce...
Hi talderton
I made some change on it please try the following code
Positive response percentage of students = DIVIDE (CALCULATE (sum('MACSIS 2019 and 2021 survey restructured'[Number of students])),CALCULATE (sum('MACSIS 2019 and 2021 survey restructured'[Number of students]),ALLEXCEPT('MACSIS 2019 and 2021 survey restructured','MACSIS 2019 and 2021 survey restructured'[Enumber]),'MACSIS 2019 and 2021 survey restructured'[Positive reponse] in {"Positive","Negative"}))Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
THanks very much. That now works to create the variable.
But how do I now use that to create the visualisation in my first post? i.e. with schools on the Y axis, the survey year on the X axis showing this calculated as the measure with the change between the two latest years shown in the final column?. Like this:
Hi talderton
You can use the following visual
But it cannot display the change , the default visuals power bi have offered cannot do this
Best Regards!
Yolo Zhu