Forum Discussion

jb0101's avatar
jb0101
New Member
1 year ago
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 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

Need Help
  • PhilipTreacy's avatar
    PhilipTreacy
    1 year ago

    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

3 Replies

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    1 year ago

    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

  • Kedar_Pande's avatar
    Kedar_Pande
    Super User
    1 year ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.