Forum Discussion

Here4Help's avatar
Here4Help
Frequent Visitor
3 years ago

Summarizing a Bar Chart with % values

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

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. 

 

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.