How to make a graph with "Quality" on the 'y' axis?

[KathyO]

We do a fortnightly-ish quality audit, where the results look like this:

Ideally I'm trying to get to either:

- a clustered column chart with date on the x-axis and Excellent/Average/Poor on the y-axis, which shows the result for each audited factor on  the date OR

- a line graph, again with date on the x-axis and quality rating on the y-axis, with lines representing each audited factor.

Usually I search, and this Forum has the answers, but this one actually has me stumped.  Is it even possible?

[KathyO]

Thank you so much, that is absolutely perfect!

[Ritaf1983]

Happy to help 😊

[Ritaf1983 · Accepted solution]

Hi @KathyO 
Since value axes in charts are designed for numerical aggregations, their value cannot be a string, but only a number. However, given that the scores in your script are fixed, you can explore a workaround to achieve the desired result.

In the first step, you should unpivot your table with PQ:

Then you'll get a vertical table :

The second step is to give the numeric score for the quality:

Result:

The third step is to create the desired graph with the needed score:

After this lock the limits of the axis according to the score:

switch off the title of the axis

create text boxes with the quality in words + put them on the y-axis values

the last step is to group all these construction

**To make the text boxes look better, you need to align them and shrink their borders as much as possible.

Pbix is attached

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly