cancel
Showing results for
Did you mean:
Helper I

## Issue with visual - the second bar

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

1 ACCEPTED SOLUTION
Super User

Create a table with the following format:

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.

Regards

Miguel Félix

Proud to be a Super User!

Check out my blog: Power BI em Português

2 REPLIES 2
Helper I

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

Super User

Create a table with the following format:

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.

Regards

Miguel Félix

Proud to be a Super User!

Check out my blog: Power BI em Português

Announcements

#### 2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

#### Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

#### 2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors