Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello All,
I have a matrix visual showing student scores in various attributes, I've created a improvement column in my data which just shows the image URL of an up/down arrow depending on the score. I've only created one of these Improvement columns so far in order to test it however the issue I'm encountering is that the Improvement column is showing after the score for every attribute rather than just the one it it is realted to despite the fact it only displays the image for the appropriate attribute.
Image of my Matrix Visual (Student names blanked out):
The code I'm using for the improvement column is:
Confidence KPI Term 1 = VAR a= IF('Link Teacher'[Attribute]="Confidence End of Week 12",MAXX(FILTER('Link Teacher','Link Teacher'[Identifier]=EARLIER('Link Teacher'[Identifier])&&'Link Teacher'[Attribute]="Confidence Start of Programme"),'Link Teacher'[Score])) return if(ISBLANK(a),BLANK(),if('Link Teacher'[Score]<a,"https://skilldrive.custardcloud.co.uk/nextcloud/index.php/apps/gallery/s/K9MlM3qRppH2pIZ",IF('Link Teacher'[Score]=a,"https://skilldrive.custardcloud.co.uk/nextcloud/index.php/apps/gallery/s/UfuwdLzP8wKr8py","https://skilldrive.custardcloud.co.uk/nextcloud/index.php/apps/gallery/s/UO9mrv0CBmW1A8t")))
And finally my data looks like:
Student Name Identifier Attribute Score
xxxxxx xxxxx Confidence end of week 12 5
Any help greatly appreciated.
Many Thanks,
Mark Clipsham.
HI, @MClipsham92
Based on my research, I'm afraid it couldn't achieve that add one custom column for only one attribute in Matrix visual in Power BI for now.
And as a workaround, you could disable Format->Column headers->Word wrap
Then reduce the width of other "Confidence KPI Term 1" column
For example:
Best Regards,
Lin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |