100% Staked Column Chart is not working

[Poongovil]

New to power BI; Still learning ... So please excuse.

I have created the below pivot table. Want to create a 100% Stacked Column chart as shown below in the table with 4 stacked bars. 

Excel Output

But I do receive only the below chart with three stacks in Power pivot. Please help !!!

What should i do to get the excel output. Thanks !!!

[Anonymous]

HI @Poongovil 

Unpivot these 4 data columns and use it in the fully stacked chart.

You will ge the desired result.

check a simple pivot example https://www.youtube.com/watch?v=T8Ekr_sLP-0

[amitchandak]

@Poongovil , please swap legend and axis column and check

[Poongovil]

Sorry it does not work.... Tried swapping the legend and axis column

[V-lianl-msft · Accepted solution]

Hi @Poongovil ,

I created a measure and used level as a legend.

Measure =
VAR COUNT_BY_LEVEL =
    CALCULATE (
        COUNT ( 'Table'[ID] ),
        ALLEXCEPT ( 'Table', 'Table'[ID type], 'Table'[level] )
    )
VAR COUNT_BY_TYPE =
    CALCULATE ( COUNT ( 'Table'[ID] ), ALLEXCEPT ( 'Table', 'Table'[ID type] ) )
RETURN
    DIVIDE ( COUNT_BY_LEVEL, COUNT_BY_TYPE )

Sample .pbix

If the problem persists,could you share the sample pbix  or sample data?(Please mask any sensitive data before uploading.)

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

[Poongovil]

Thank you. That works!!!