Making shadowed stacked column chart with slicers

[GrimReaperX]

Hello guys, 

I am trying to figure out how to create a stacked column chart reflecting a shadow connected dynamically with slicers ? I've seen it in the Gartner Life Expectancy dashboard which is as below. Any idea how to create this kind of dynamic column chart without using selection pane ? 

Link as follows (Gartner Analytics and BI Virtual Bake-Off 2020: world population health analysis with Power BI - You...)

Thank you.

[v-yanjiang-msft]

Hi @GrimReaperX ，

According to your description, I create a sample.

In the column chart, Column1 is in the Axis. Here's my solution.

1.Create a new table, don't make relationship between the two tables.

Table 2 = VALUES('Table'[Column1])

2.Create a measure.

Measure = IF(MAX('Table'[Column1])>= MAX('Table 2'[Column1]),"Grey","Blue")

3.In the column chart formatting pane>Columns>Colors, click the fx button.

Select the new measure in the color formatting based on field.

4.Put the column from the new table in a slicer, get the result.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GrimReaperX]

Hi @v-yanjiang-msft ,

Thanks for your answer, i greatly appreciate that. Is it also possible to apply different colors on the chart based on different buckets? As you can see from the picture that i shared in first post, there is different colors for specific range.

Moreover, is it possible to hide section below in the slicer? I just want to have slicer itself without any text. 

Thank you very much.

[v-yanjiang-msft · Accepted solution]

Hi @GrimReaperX ,

You can apply different colors on the chart based on your condition, for example in my sample, I modify the color formula like this:

Measure =
IF (
    MAX ( 'Table'[Column1] ) >= MAX ( 'Table 2'[Column1] ),
    "Grey",
    IF (
        MAX ( 'Table'[Column1] )
            >= MAX ( 'Table 2'[Column1] ) - 5,
        "Orange",
        "Blue"
    )
)

Get the result. But in the slicer, the text can't be hided, it's by design.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.