Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Bar Chart Segmentation

Hi everyone,

 

I want to create segments in each of this bar chart. I want to divide each bar in 3 proportionate categories representing one color. Three colors are for 1. "how many people have less than 20% Digital Fluency?" 2. "how many people have between 20% and 60% Digital Fluency?" and 3. "how many have more than 60% digital fluency?". 

I want to perform this action for each bar. 

thank you in advance. 

 

Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

5 Replies

  • Idrissshatila's avatar
    Idrissshatila
    Super User
    3 years ago

    Hello Anonymous ,

     

    so you need to define these as a calculated column then you have a column that has 3 options in it, then you add it as a legend in the chart.

     

    If I answered your question, please mark my post as solution, Appreciate your Kudos đź‘Ť

    Follow me on Linkedin
    Vote For my Ideađź’ˇ

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thank you for the reply. I have tried to do that (scheenshot attached), but then the x-axis is going up to 150%. It is adding % values of all 3 segments. What am I doing wrong? 

       

       

       

      • Idrissshatila's avatar
        Idrissshatila
        Super User
        3 years ago

        Hello Anonymous ,

         

        The value should be count of people so that you know how many people in each color segment.

         

        If I answered your question, please mark my post as solution, Appreciate your Kudos đź‘Ť

        Follow me on Linkedin
        Vote For my Ideađź’ˇ

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi. Can you Please elaborate? Attaching my calculations below.

    Benchmark = DIVIDE([Count],[Total Count])
    Count = SUM('DigitalLiteracy_chart'[Likert Value])
    Total Count = (5*COUNT('DigitalLiteracy_chart'[Likert Value]))