Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
botty1963
New Member

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.

 

botty1963_0-1606837729073.png

 

1 ACCEPTED SOLUTION
v-stephen-msft
Community Support
Community Support

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.

4.png6.png7.png

 

 

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.

View solution in original post

2 REPLIES 2
v-stephen-msft
Community Support
Community Support

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.

4.png6.png7.png

 

 

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.

S_JB
Resolver III
Resolver III

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.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.