Forum Discussion

kanwal's avatar
kanwal
Frequent Visitor
3 years ago
Solved

Pie Chart with 100% values

Hi Everyone,   I have below 2 visuals, bar chart and Pie chart. In pie chart I would like to show Planned as always 100% and show on top of Actual%. Data in Bar chart is correct but obvisually Pie...
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    Percentages are used to illustrate the gap between the target and the actual.
    You can put the number on the toltip once you have "drawn" it.
    My embarrassment is that I cannot find the file in the post.

    If you would like, I can create a new one with bullet charts by months, like the picture on the right, and insert
    Percentage in the tooltip.

     

  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    Hi kanwal 

    There are four different visuals that can be used to display the scenario of a target versus an actual in the following file.

    1. Simply presenting the gap by months.

    2.On the second graph, you can see the percentage of completions

    3. The third graph shows the performance and target in nominal terms.
    Based on the distance between the bar and the target line, the gap can be estimated.
    As a supporting figure, the gap percentage itself is on the tooltip

    4. "Table graph" that shows the gap, performance, target, and trend of the gap for each category.

    Here is the link to download the PBIX
    https://github.com/MadeiraData/MadeiraToolbox/blob/master/Power%20bi/Various%20visualizations%20for%20actual%20vs%20targets%20scenario.pbix 


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

  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    It is the right type of graph if you want to convey a trend about the gap, but its design is less effective.
    I've already attached a file with examples.
    The accuracy of the design is of utmost importance 🙂
    Wishing you good luck