Forum Discussion

GrimReaperX's avatar
GrimReaperX
Icon for Helper II rankHelper II
4 years ago
Solved

Making shadowed stacked column chart with slicers

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...
Need Help
Show and Tell
Tips and Tricks
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    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.

v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
4 years ago

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's avatar
    GrimReaperX
    Icon for Helper II rankHelper II
    4 years ago

    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's avatar
      v-yanjiang-msft
      Icon for Community Support rankCommunity Support
      4 years ago

      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.