Forum Discussion
Conditionally Format Column Chart
Hi,
I am currently working with an unstructured dataset that looks like this.
It basically shows the year, the different subjects (A,B,C) and the number of students obtaining the marks 50-60 at school and state level. The data is to be read in rows.
Eg Subject A, 1 student got a mark of 52 at school level where as 123 students got the same mark at state level.
I want to create a custom column chart where it has the marks (50-60) on the x-axis. The number of students on the y-axis. The column chart is to display data of students at state level however, where there are students obtaining the same marks at school level it must show that "bar" as a different colour. See Image below for desired results for subject A visual
As I hover over the score 52 and 55, I can see there were 1 and 4 students who recieved the same mark. Obviously, will need slicers namely in subjects and year.
I'm able to do this in excel, but can't seem to figure it out on Power Query/Power BI.
Any help/direction is greatly appreciated.
5 Replies
- Ashish_MathurSuper User
Hi,
Share data in a format that can be pasted in an MS Excel file.
- bobbob123Helper III
Hi Ashish,
Here you go.
2022 Subject A 50 51 52 53 54 55 56 57 58 59 60 2022 School 1 4 5 8 2022 State 235 116 123 979 257 807 651 224 932 330 797 2022 Subject B 50 51 52 53 54 55 56 57 58 59 60 2022 School 10 3 6 4 1 2022 State 928 918 362 191 59 642 794 249 164 646 201 2022 Subject C 50 51 52 53 54 55 56 57 58 59 60 2022 School 13 5 6 8 9 2022 State 113 822 72 787 378 917 880 494 303 134 259 - Ashish_MathurSuper User