Bar Chart Segmentation

[Anonymous]

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. 

[Anonymous]

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]))

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[Idrissshatila]

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]

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]

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💡