Create Stacked and clustered Column chart

[Anonymous]

Hello there,

I want to create a chart which should be combination of Clustered and Stacked columns.

I have a data in this format

Projekt  dept  year    Month     value      Projekt+year

MS         BL     2020     Feb       10           MS 2020

SR          BL      2020     April    20           SR 2020

SR          HB      2020     June    20           SR 2020

SRK        hB     2020     April     20.5        SRK 2020

MS         BL     2021     April        30          MS 2021

SR          BL      2021    April     30.8        SR 2021

SRK        hB     2021    June      20.7        SRK 2021

Now, I need a Visualisation of clustered and stacked column chart. On Xaxis there should be  each month, containing two bars for every month.

For each month, the first bar should only show SR values of 2020 and second bar should be stacked one, with all the values(Ex: MS+SR+SRK) of 2021 stacked one upon another.

Please guide me through this.

TIA

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

You can try visual "Clustered Stacked bar chart "  in App Source.

 
Then you can create the following visual filter measure  and apply it to visual filter pane.

visual filter = 
IF (
    SELECTEDVALUE ( 'Table'[Year] ) = 2020
        && SELECTEDVALUE ( 'Table'[Project] ) <> "SR",
    0,
    1
)

Please  check my sample file for more details.

Best Regards,
Community Support Team _ Eason