Forum Discussion

prepo's avatar
prepo
Regular Visitor
8 years ago
Solved

Tracking maturity trends - DevOps dashboard

Hello,   We'd like to build a dashboard to showcase the improvement in maturity level in our DevOps approach. The data is hosted on OneDrive which is linked to the PowerBI service. I have attach...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi prepo,

     

    As a workaround, maybe you can use numeric values to represent the level of maturity. 

     

     

    For these two tables, you could add a conditional column which lists unique numbers for each level type. Then, in data table, refer to numerical column via LOOKUPVALUE so that text values are converted to numbers. Add numerical column to chart visual.

     

    Regards,

    Yuliana Gu

  • prepo's avatar
    prepo
    8 years ago

    That helped, thank you for your suggestion. For some reason I am unable to mark your comment as the solution. Noting it here

    As a workaround, maybe you can use numeric values to represent the level of maturity. 

     

    1.PNG

     

    For these two tables, you could add a conditional column which lists unique numbers for each level type. Then, in data table, refer to numerical column via LOOKUPVALUE so that text values are converted to numbers. Add numerical column to chart visual.

     

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi prepo,

 

Then, what is your desired output with above sample tables? Please provide more description about your requirement.

 

Regards,

Yuliana Gu

prepo's avatar
prepo
Regular Visitor
8 years ago

The output would be to visually represent the level of maturity on a monthly basis for each area per app. Since some of the apps take several months to move from one level to another, it is imperative to showcase the current status. I have represented a sample of how the data could be represented, any advice is welcome. Let me know if you have any questions.

Thank you!

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi prepo,

     

    In Power BI desktop, it is not possible to display text values on Y-axis in a chart visual. Y-axis only supports aggregated numerical fields. I'm afraid your requirement might not be achievable right now.

     

    Regards,

    Yuliana Gu

    • prepo's avatar
      prepo
      Regular Visitor
      8 years ago

      do you have any recommendations to convert such matrices to calculate a weighted average and represent the text into numbers.Thanks!

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Microsoft Employee
        8 years ago

        Hi prepo,

         

        As a workaround, maybe you can use numeric values to represent the level of maturity. 

         

         

        For these two tables, you could add a conditional column which lists unique numbers for each level type. Then, in data table, refer to numerical column via LOOKUPVALUE so that text values are converted to numbers. Add numerical column to chart visual.

         

        Regards,

        Yuliana Gu