Unanswered

What are some of the best ways to design charts in Power Apps?

(1) Share

Report

Posted on by MelaninCoded

Hi,

I'm looking for some of the best approaches to building or designing charts in Power Apps.
The out of box charts do not provide enough options and improvising using Power Apps' built in control can be clunky.

What are some of the best ways to design charts in Power Apps?

While researching I came across this quickchart io site that came a bit close and was wondering what others recommend on here.

Thank you.

Sample code:
//The expense of the item/Total amount of the budget

With((Percentage: ThisItem.Expense/Sum(Filter(ExpenseByCategoryCollect, BudgetId =Gallery1.Selected.BudgetId),Expense)*100},

"https://quickchart.io/chart?c=" & EncodeUrl(

type: 'radialGauge',

data: {

datasets: [{

data: ["& Percentage &"],

backgroundColor: getGradientFillHelper( 'horizontal',[' red', 'blue']),

}]

options:{

domain: [0, 100],

trackColor: '#f8f7f9',

centerPercentage: 80,

centerArea: {

text: (val) => val + '%',

}
}"))

Categories:

General Questions

Using Apps Using Formulas

All responses (3)

Answers (0)

Mark Nanneman 329 on at

Like (0)

Report

What are some of the best ways to design charts in Power Apps?

Using formulas like what you have in image controls is an interesting method--of course it all depends on the external service being available.

Integrating PowerBI charts is a powerful option--there's a bit of a learning curve to figuring out.

I've also sometimes just built my own charts, using galleries, containers and other controls and then adding formulas to the X and Y, dimension and color properties that change depending on the datapoints I want to display.

It's not the most practical thing, but I once built a Gannt Chart from scratch in powerapps, using nested galleries and containers.
Suggested answer

timl 32,024 on at

Like (0)

Report

What are some of the best ways to design charts in Power Apps?

Hi MelaninCoded

I would also recommend that you take a look at the Canviz chart components.

https://ogcanviz.github.io/ChartComponents/#/
Suggested answer

jpespena 287 on at

Like (0)

Report
What are some of the best ways to design charts in Power Apps?

Hi MelaninCoded,

I frequently use Quickcharts on creating visualizations for apps that I build. Just need some fixing on your existing code:

- With() function should start with With({ not With((

- Remove extra space in ' red' in backgroundColor

- Remove )1 after the dataset which both cause error.

It should be like this:

With({Percentage: ThisItem.Expense/Sum(Filter(ExpenseByCategoryCollect, BudgetId =Gallery1.Selected.BudgetId),Expense)*100}, "https://quickchart.io/chart?c=" & EncodeUrl( "{ type: 'radialGauge', data: { datasets: [{ data: ["& Percentage &"], backgroundColor: getGradientFillHelper( 'horizontal',['red', 'blue']), }] }, options:{ domain: [0, 100], trackColor: '#f8f7f9', centerPercentage: 80, centerArea: { text: (val) => val + '%', }, } }"))