CODEWITHSUNDEEP
powerbipowerbi-desktopstacked-chart
Nithin Mohan
Nithin Mohan

Reputation: 770

Stacked column chart not getting as expected in power bi

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

Upvotes: 0

Views: 675

Answers (1)

AxxM
AxxM

Reputation: 11

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

Upvotes: 0

Related Questions