Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
The goal is to display a ratio on a multi-row card. I am aware that the multi-row card can only display numbers but looking for advice on how to make this work. I tried to convert both the entire ratio + portions of the ratio into number using VALUE but it is not formatting the correct way. Any advice on how to display a ratio on Multi-Row Card as a number will be greatly appreciated.
Current Syntax (notice screenshot below as the ratio is reflected in BLUE >>> the goal is to reflect the ratio as a number in black like the other numbers)
VALUE( [Overdue Lifecycle Count] ) & " / " & VALUE( [Pattern Count] )
Solved! Go to Solution.
You can display text in multi-row cards. Are you getting an error that makes you think otherwise? If so, the root cause is not the visual's capabilities.
Example:
Number = 87462
Percent = .12365
Ratio1 = 10 & " / " & 3
Ratio2 = 30 & " / " & 1
Ratio3 = 2 & " / " & 5
Text = "Hello World!"
@MarkLaf thanks for the advice. I ultimately had to get rid of all the fields and drop them back in to get the formatting corrected. This put the ratio into the correct format.
@MarkLaf thanks for the advice. I ultimately had to get rid of all the fields and drop them back in to get the formatting corrected. This put the ratio into the correct format.
@Anonymous
Format(Divide(Numerator,Denominator),"%") and see whether it works!
Proud to be a Super User!
You can display text in multi-row cards. Are you getting an error that makes you think otherwise? If so, the root cause is not the visual's capabilities.
Example:
Number = 87462
Percent = .12365
Ratio1 = 10 & " / " & 3
Ratio2 = 30 & " / " & 1
Ratio3 = 2 & " / " & 5
Text = "Hello World!"
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!