Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Working on KPI dashboard in which I would need to show the top 3 corporations in the bar chart and show % delta change and share of investments in the cards beside to the chart (as shown below). the top 3 corps are vary based on country selection. I'm facing challenges to calculcate % changes for each corporation and show in the card, as the corporations would vary and how can i capture the corporation and calculate % changes?
Thanks,
Sankar M
Solved! Go to Solution.
Followed by my trail post, in multi-row card there is no option to set display units.
Looking forward your kind suggestions/thoughts.
Hi @msaninfo
I think you can build a measure to calculate % changes .
Due to I don't know your data model, I build a sample to have a test.
I add a Rank column in my sample.
RANK = RANKX(FILTER('Table','Table'[Country]=EARLIER('Table'[Country])),'Table'[Current],,DESC,Dense)
Measures:
Measure = CALCULATE(SUM('Table'[Current]),FILTER('Table','Table'[RANK]<=3))-CALCULATE(SUM('Table'[LAST]),FILTER('Table','Table'[RANK]<=3))
SOI = [Measure]/CALCULATE(SUM('Table'[LAST]),FILTER('Table','Table'[RANK]<=3))
Result:
You can see dynamic SOI by select Slicer.
You can download the pbix file from this link: Calculate % change for multiple series show in card
If this reply still couldn't help you solve your problem, please show me your data model and tell me your calculate logic of SOI.
Or you can share your pbix file with me by your Onedrive for Business.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Rico Zhou, thank you so for comments. I have manged to drive the KPI metrics for top 3 corporation as per your instructions and showing in multi-row card. However, I'm facing a challenges, as there is no option to apply conditional formatting based on % change (+ve, -ve) in multi-row card. For ALL CORPORATION, I have calculated % change and showing in a single card with conditional formatting (with UNICHAR), but not able to apply same for multi-row card. (PBI screenshot for your reference). Do you have any suggestion??
Thanks in advance.
Sankar M
Followed by my trail post, in multi-row card there is no option to set display units.
Looking forward your kind suggestions/thoughts.
Finally, I got a solution. I have used Matrix instead multi-row card and applied the formatting/icons as needed.
Thank you so much for your suggestions/mentors on right time..
Sankar M
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |