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

     

     

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.