Forum Discussion

botty1963's avatar
botty1963
New Member
5 years ago
Solved

Display my percent data

I'm sure for a non-newbie that this is a simple issue, but I can't find the answer and all the YouTube clips that I have watched, all relate to some calculation to create a percentage. I have a table that has a month column, then 4 columns for different incident priorities. And those columns are populated with percentages. I just want PBI to show a chart with the months along the bottom and bars showing the percentage values with labels - like the simple Excel chart I have for last year. I am guessing that I have to change the source data where the percentages are, and then change the format in PBI but can't work it out.

 

 

Need Help

2 Replies

  • S_JB's avatar
    S_JB
    Resolver III
    5 years ago

    Based on your dataset already including the relevant month field and 4 percentages you could try the following:

     

    Create a clustered column chart visual, pull the month field into axis then pull the 4 relevant percentage fields into values. This should create a bar chart showing the 4 percentages for each month.

     

    Turn on data labels by going into format.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi botty1963 ,

     

    You may try to create a Stacked column chart, then put your date column to Axis and percent column to Valus. The date hierarchy retains the year and month, and expand all down one level in the hierarchy. To show the percentage values with labels, mark sure the Data labels is on.

     

     

    You can check more details from here.

     

    Reference: Introduction To Power BI Visuals - Part Two (Stacked Column Chart)

                      Drill mode in a visual in Power BI

                      How to use Date vs Date Hierarchy in Power BI

     

    Best Regards,

    Stephen Tao

     

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