Forum Discussion

Frequent Visitor

6 years ago

Solved

100% Staked Column Chart is not working

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 !!!

V-lianl-msft
6 years ago
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.

5 Replies

Anonymous
Not applicable
6 years ago
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
Super User
6 years ago
Poongovil , please swap legend and axis column and check
- Poongovil
  Frequent Visitor
  6 years ago
  Sorry it does not work.... Tried swapping the legend and axis column
  - V-lianl-msft
    Community Support
    6 years ago
    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.

Related content