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,

 

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