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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors