Forum Discussion
Guidance for PBI Matrix / Table to present defect id ( Superscript) to status
Dear Community
We have a requirement to show defect ID associated with Status in a ( subscript ) manner, and I was wondering how can I achieve it.
By far using Matrix visual only be able to summarize status but yet failed to link defect ID in Superscript format.
Final requirement example as below : ( Defect IDs are red highlighted)
RAW DATA :
Using PBI Matrix, I am yet able to plot the Status table but yet not able to superscript the Defect ID ( say in the above example Scenero1 Node 1 has:3903)
Any leads or support would be appreciated.
Best Regards.
see how you solved your question
I solved it in two waysignore the Scenarios 4, it's me who made these numbers for verification
https://dropmefiles.com/YXgzCАхмед-kazakhstan
10 Replies
- Ahmedx
Super User
see how you solved your question
I solved it in two waysignore the Scenarios 4, it's me who made these numbers for verification
https://dropmefiles.com/YXgzCАхмед-kazakhstan
Hi Ahmed
Many thanks for your suggestion & help but when there is 2 Defect attached to the status . this function suggested by you is not working
could you suggest how this code needs to change to have "space " & "Comma" to separate Defect ID in the Def column ...
Many Thanks, Ahmed for your guidance. Now I am able to superscript Defect ID's into my matrix table .but wondering if can we use different color codes for status ( say Green for a pass, red for failed ) and only Blue color to indicate all defect ID superscripts.
mshaoHelper III
Dear community,
I want to get the same display format in Power BI report builder, Do you have any ideas?
Thanks
- Ahmedx
pls try
- Ahmedx
- Ahmedx
- Ahmedx
and how will you determine by what criteria
