Forum Discussion
Tracking maturity trends - DevOps dashboard
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
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.
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.
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!
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
do you have any recommendations to convert such matrices to calculate a weighted average and represent the text into numbers.Thanks!
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
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.
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.