Forum Discussion
How to Decide Visuals for Particular Charts/Tables
Hello,
First, look at what your data represents and what you want to communicate. Decide what the key mesage or insights you want to convey
- Are you trying to show the distribution of accounts across different types?
- Do you want to highlight which account types have the most financial impact?
- Is the comparison between the number of accounts and the amount of cash received important?
In terms of visuals you could use :
1) bar or column charts for showing distribution of accounts
2) bar chart with AccountType and TotalCashReceived to quickly identify main account types
3) Stacked Column chart if you want to show how each account type contributes to the total number of accounts
4) Pie or Donut chart for proportionate Comparison
5) Scatter chart for relationship analysis.
It all depends on the story you want to tell, the angle you want to take and the relationship between the other elements you include in the report (other graphs, labels, etc etc).
If it helps, please mark my reply as the solution. Thanks
Hello,
First, look at what your data represents and what you want to communicate. Decide what the key mesage or insights you want to convey
- Are you trying to show the distribution of accounts across different types?
- Do you want to highlight which account types have the most financial impact?
- Is the comparison between the number of accounts and the amount of cash received important?
In terms of visuals you could use :
1) bar or column charts for showing distribution of accounts
2) bar chart with AccountType and TotalCashReceived to quickly identify main account types
3) Stacked Column chart if you want to show how each account type contributes to the total number of accounts
4) Pie or Donut chart for proportionate Comparison
5) Scatter chart for relationship analysis.
It all depends on the story you want to tell, the angle you want to take and the relationship between the other elements you include in the report (other graphs, labels, etc etc).
If it helps, please mark my reply as the solution. Thanks
Hi Resolver,
This is brilliant. It's very insightful. Your statements I will definitely keep as a reference to be reviewed whenever I build a visual.
I think a lot of Power BI designers will take a lot from what you said.
Thank you