Display cell % value in visualisation

[jb0101]

Hi,

I need to show project progress in a visulaisation. I have the value, displayed as a %, in a cell that I want to show as % complete visualisation. The value isn't generated by a formula, rather just entered manually by the project manager. But every time I try to display in a donut or it just shows the value as 1.

Here is what I want it to look like, and how I have the data:

Any help would be greatly appreciated!

Thanks

[Anonymous]

Thanks for the reply from PhilipTreacy and Kedar_Pande.

Hi @jb0101 ,

Has your problem been solved, if the replies are helpful to you, please mark them as solutions, if you expect the effect to want to be exactly the same as in the picture, you may need to add two rows to the data source, here's how I did it:

1. Add the following two rows:

2.Take project B for example, select B and 1-B.

3.Clarify the interaction effect between two visuals:

4.The result is as follows:

Best Regards,
Zhu
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[Kedar_Pande]

Check that the column % complete is correctly set as a decimal number type and not as an integer. If it's incorrectly formatted as an integer, Power BI will interpret values like 0.64 as 1, leading to incorrect visual representation.

[PhilipTreacy · Accepted solution]

Hi @jb0101 

Download PBIX file with example shown below

Donuts aren't the best/right way to show this data. Use a Gauge instead.

I've put a filter on these to only display data for the corresponding project i.e. either A or B.  If you have project data in separate tables you won't need to do this.

I've added the name of the project to the visual title.  You can remove this and use a card visual if you like.

Regards

Phil