Visual to use which shows total number against number started and number completed

[daniellamoore29]

Hi,

I have a table which shows total number given planning consent, total number started, and total number completed. 

How do I show this on a visual for separate years please?

[Ritaf1983]

Hi @daniellamoore29 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[daniellamoore29]

@Ritaf1983 

Metric Name	Metric Value
Number given planning consent	100
Number started - keyworker homes	80
Number completed - keyworker homes	20

[daniellamoore29]

@Ritaf1983  To show a visual which shows total no. of homes given planning consent, against total no. started and toal no. completed

[Ashish_Mathur]

Hi,

Create a clustered column chart.  Drag Years to the X-axis from the Calendar Table.

[Ritaf1983 · Accepted solution]

Hi @daniellamoore29 
If I understood you correctly, you are asking for advice from an effective data visualization perspective. Choosing the appropriate graph depends on what you want to convey with these numbers. If you want to compare these three metrics, such as in a funnel-like process, a simple bar chart is the best way to represent this information.

You can also download the PBIX from This link 

If it is something else, please give more details.

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