Issue with visual - the second bar

[dgadzinski]

Hello, 

I have an issue. I need to show:

• Maturity for groups
• Implemented and Missing value for groups
  Calculation: 
• Existing Low (Maturity): count if column Maturity = "Low"
• Existing Medium (Maturity): count if coulumn Maturity = "Medium"
• Existing High (Maturity): count if column Maturity = "High" 
• Missing/ Planned = Count if column Status = "Planned" 
• Implemented = Count if Status = "Implemented" 

I want to show all calculation as below:

The first bar: Implemented + Planned
The second bar: High + Medium + Low 

This is very important but I have no idea how to do this. Could you help me?

https://uewrc-my.sharepoint.com/:u:/g/personal/170361_student_ue_wroc_pl/EXPbaJKQPytDlDzYBupyCS4B4eR...

[dgadzinski]

@MFelix thanks a lot! This is the best solution! 

[MFelix · Accepted solution]

Hi @dgadzinski ,

Create a table with the following format:

Add the following measure:

Values for chart = SWITCH(SELECTEDVALUE('Type'[MetricSort]),
                        1, [Implemented],
                        2, [Planned],
                        3, [High],
                        4, [Medium],
                        5, [Low])

Setup your char wiht the following setup:

• Y-Axis: Group + Category
• X-Axis: Value for chart
• Legend: Metric

Drill down to the lowest level and sort axis by group category:

If you want to wrap the name you need to use the Stacked column chart:

See file attach.