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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Here4Help
Frequent Visitor

Summarizing a Bar Chart with % values

I have a very simple table with % values as below:

Here4Help_1-1678190697031.png

I created a bar chart to represent the data. However, I now want to summarize the data. Using Smart Narrative is not working since it just adds up all the % values as below. 

 

Here4Help_0-1678190634449.png

I am trying to use measures in Text box and I am struggling with the measures. 

For example, I want to be able to say - In 2017/18 A had the highest %sale of 67% followed by B,C,D. 

Now the data will change, so I have a measure to get the maximum year and the highest % sale in that year. But unable to get the product names since they all have the same % that year. 

Similarly any good way to find the growth rate % for products between max and min year. Like, the Product B had the lowest growth % (with value here) between 2015/16 and 2017/18 and Product A had the highest growth %. 

Our Product is B, so the summary needs to focus on that. 

Thanks a lot. 

 

 

2 REPLIES 2
amitchandak
Super User
Super User

@Here4Help , Create measures with help from the index function

 

Power BI Index function: Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thanks, but it doesn't help display all the options when there are same values. 

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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