The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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.
@Here4Help , Create measures with help from the index function
Power BI Index function: Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U
Thanks, but it doesn't help display all the options when there are same values.
User | Count |
---|---|
65 | |
60 | |
55 | |
54 | |
31 |
User | Count |
---|---|
180 | |
88 | |
70 | |
46 | |
46 |