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?
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
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
Helpful resources
Europe’s largest Microsoft Fabric Community Conference
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
