Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
rakikumarpatra
Frequent Visitor

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)

 

rakikumarpatra_0-1671355311091.png

 

 

RAW DATA :

 

rakikumarpatra_1-1671355311093.png

 

 

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)

 

rakikumarpatra_2-1671355311094.png

 

 

Any leads or support would be appreciated.

 

Best Regards.

1 ACCEPTED SOLUTION
Ahmedx
Super User
Super User

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

Screen Capture #162.png

Ахмед-kazakhstan

View solution in original post

10 REPLIES 10
Ahmedx
Super User
Super User

and how will you determine by what criteria

Ahmedx
Super User
Super User

Ahmedx
Super User
Super User

i can only do this

Screen Capture #180.png

https://dropmefiles.com/uyHKF

Ahmedx
Super User
Super User

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

Screen Capture #162.png

Ахмед-kazakhstan

Dear community,

 

I want to get the same display format in Power BI report builder, Do you have any ideas?

 

Thanks

pls try

 

Thank you so much for your kindly help!

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_0-1671713935851.png

 

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.

 

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],""),"’","’ ")

Screen Capture #185.png

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.