Forum Discussion

GrimReaperX's avatar
GrimReaperX
Helper 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 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 - YouTube)

Thank you.

 

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.

3 Replies

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community 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
      Helper 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
        Community 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.