Forum Discussion

bobbob123's avatar
bobbob123
Icon for Helper III rankHelper III
3 years ago
Solved

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 ...
Need Help
Show and Tell
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

Share data in a format that can be pasted in an MS Excel file.

  • bobbob123's avatar
    bobbob123
    Icon for Helper III rankHelper III
    3 years ago

    Hi Ashish,

     

    Here you go.

     

    2022Subject A5051525354555657585960
    2022School  1  4 5 8 
    2022State235116123979257807651224932330797
    2022Subject B5051525354555657585960
    2022School10  3 6 4 1 
    2022State92891836219159642794249164646201
    2022Subject C5051525354555657585960
    2022School13 56   8  9
    2022State11382272787378917880494303134259
    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      3 years ago

      Hi,

      You may download my PBI file from here.

      Hope this helps.

      • bobbob123's avatar
        bobbob123
        Icon for Helper III rankHelper III
        3 years ago

        Hi, 

         

        Thank you for your response.

         

        This is a column and line graph, i need the visual to be a column graph only. Where there is an overlap with schools and state, the "column" will be displayed a different colour. I've attached an image in my post for reference.