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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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!"
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 88 | |
| 82 | |
| 68 | |
| 64 |