Forum Discussion
Solved
Display cell % value in visualisation
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 ...
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
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.