Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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.
Solved! Go to Solution.
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
and how will you determine by what criteria
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
Dear community,
I want to get the same display format in Power BI report builder, Do you have any ideas?
Thanks
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 ...
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],""),"’","’ ")
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
77 | |
60 | |
52 |
User | Count |
---|---|
165 | |
86 | |
68 | |
68 | |
58 |