Stacked column chart not getting as expected in power bi

0
votes

I am plotting a sound sensor data chart based on following table in PowerBi.

datatable

The expected graph should be like this

enter image description here

But when I tried to plot it in PowerBi I am getting the graph as follows enter image description here

I can't change Y axis graph and it showing the sum of the columns. How can I set the readings as shown in the actual graph.

Here is the settings image

enter image description here

The Color column condition is 

Color = IF ([Content.Leq] < VALUE([Content.AverageAmbientNoise]),"blue",if ([Content.Leq] >= VALUE([Content.AverageAmbientNoise]) && [Content.Leq] < 85,"yellow",if ([Content.Leq] >= 85,"red")))

Is it possible to create the exact graph? If anybody provide the logic that will be very helpful

1
powerbipowerbi-desktopstacked-chart
You will not be able to recreate the graph you showed with a stacked bar/column chart in power bi – Jon

1 Answers

0
votes

You should add the color values as a calculated column, this will add the colors in the visualization.

Turning on "data labels" will show the values of each subcategory:

enter image description here