Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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/EXPbaJKQPytDlDzYBupyCS4B4eRwHQXt94_D-VcYY046ig?e=1E1dvI

Need Help
  • MFelix's avatar
    MFelix
    3 years ago

    Hi Anonymous ,

     

    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.

     

     

2 Replies

  • MFelix's avatar
    MFelix
    Super User
    3 years ago

    Hi Anonymous ,

     

    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.

     

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    MFelix thanks a lot! This is the best solution!