Forum Discussion

rakikumarpatra's avatar
rakikumarpatra
Frequent Visitor
3 years ago
Solved

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 summ...
Need Help
Tips and Tricks
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    see how you solved your question
    I solved it in two ways

    ignore the Scenarios 4, it's me who made these numbers for verification
    https://dropmefiles.com/YXgzC

    Ахмед-kazakhstan

rakikumarpatra's avatar
rakikumarpatra
Frequent Visitor
3 years ago

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 ...

 

rakikumarpatra's avatar
rakikumarpatra
Frequent Visitor
3 years ago

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.

 

  • Ahmedx's avatar
    Ahmedx
    Icon for Super User rankSuper User
    3 years ago

    i have modified the code, you can use the following:
    Sympol_2 = var _tblSympol=FILTER(
    ADDCOLUMNS (
    ADDCOLUMNS (
    CROSSJOIN (
    DISTINCT ( 'tbl'[Defect] ),
    SELECTCOLUMNS ( GENERATESERIES ( 1, 30, 1 ), "_Value", [Value] )
    ),
    "@Numercic", MID ( [Defect], [_Value], 1 )
    ),
    "@Sympol",

    LOOKUPVALUE ( simpls[Symbol], simpls[Numeric], [@Numercic] )

    ),[Defect]<>"")
    Return
    [status]& SUBSTITUTE(CONCATENATEX(_tblSympol,[@Sympol],""),"’","’ ")