cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dgadzinski
Helper I
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:

dgadzinski_0-1669970603116.png

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
MFelix
Super User
Super User

Hi @dgadzinski ,

 

Create a table with the following format:

MFelix_0-1670004086882.png

 

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:

 

MFelix_1-1670004180497.png

 

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

 

MFelix_2-1670004223643.png

 

See file attach.

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

2 REPLIES 2
dgadzinski
Helper I
Helper I

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

MFelix
Super User
Super User

Hi @dgadzinski ,

 

Create a table with the following format:

MFelix_0-1670004086882.png

 

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:

 

MFelix_1-1670004180497.png

 

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

 

MFelix_2-1670004223643.png

 

See file attach.

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Carousel_PBI_Wave1

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.

Power BI Summit Carousel 2

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!

Thank you 2022 Review

2022 Monthly Feature Releases

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