Since it is not possible to do it with Power apps Chart I Used a, API to do it. Don't worry it's a simple one.
Basically you can replace the Chart component with a simple image controll. In the Image you need to put this Code:
"https://quickchart.io/chart?c={
type: 'line',
data: {
labels: ["&Concat(colGraph,Quartal,",")&"],
datasets: [
{
label: 'Value',
backgroundColor: 'rgb(255, 99, 132)',
borderColor: 'rgb(255, 99, 132)',
data:["&Concat(colGraph,Value,",")&"],
fill: false,
},
{
label: 'Value2',
fill: false,
backgroundColor: 'rgb(54, 162, 235)',
borderColor: 'rgb(54, 162, 235)',
data:["&Concat(colGraph,Value2,",")&"],
},
],
},
options: {
responsive: true,
title: {
display: true,
text: 'Line Chart',
},
tooltips: {
mode: 'index',
intersect: false,
},
hover: {
mode: 'nearest',
intersect: true,
},
scales: {
xAxes: [
{
display: true,
scaleLabel: {
display: true,
labelString: 'Quartal',
},
},
],
yAxes: [
{
display: true,
scaleLabel: {
display: true,
labelString: 'Value',
},
},
],
},
},
}"
colGraph needs to be replaced by your Database and Quartal, Value and Value2 have to be replaced with your columns.
When the Database gets refreshed the Chart refreshes also automatically.
Here's what it looks like:
The colors can be changed with the borderColor inside the code.
You can use it for free if it's not used commercially.
If you have any question don't hesitate.
If this solved your Problem accept this solution so others can find it as well.
If it helped in any other way consider liking it so we can keep supporting eachother.
