Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
In a Table visual, is there a way to put a line return within one of the column headers ?
Similarly, is there a way to force a new line on the field name within a Card visual ?
I have columns and cards where they are wide enough to take part of what would sensibly look better showing on a second line, so I need to narrow down the column/card to force a new line where I want it, but then risk the data showing incorrectly.
Easiest demonstrated on a Card, but the same applies to columns in a Table
E.g. vs
I've not found a solution so far but any suggestions welcome
Regards
Fred
Solved! Go to Solution.
Hi @MitieFred ,
Have you try to explicitly enter a newline character by pressing Alt-Enter in the formula bar? Please refer to the OwenAuger 's reply in https://community.powerbi.com/t5/Desktop/how-to-get-text-in-new-line-in-the-data-cards-label/td-p/44...
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
@MitieFred , You can try unichar(10), but it might work in some cases
https://community.powerbi.com/t5/Desktop/Line-break-in-a-visual/td-p/226739
Hi, yes, seen and tried that, sadly that simply displays UNICHAR(10) in the middle of the Field name.
I tried various methods of imbedding without success.
Hi @MitieFred ,
Have you try to explicitly enter a newline character by pressing Alt-Enter in the formula bar? Please refer to the OwenAuger 's reply in https://community.powerbi.com/t5/Desktop/how-to-get-text-in-new-line-in-the-data-cards-label/td-p/44...
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Thanks for that pointer, the Alt + Return is definitely something to remember and I'm certainly getting closer to the desired result . . .
Original card and code
AvgStorySpend = DIVIDE(
CALCULATE(
SUM(Tasks[SAPActualCost])),
CALCULATE(
COUNT(Tasks[MilestoneType]),
FILTER(Tasks,Tasks[MilestoneType]="QIC - User Story" &&
Tasks[Task % Complete]=1)),
0
)
Revised Card and new code
NewLineAvgStorySpend =
VAR Newline =
"
"
Return
FORMAT(
DIVIDE(
CALCULATE(
SUM(Tasks[SAPActualCost])),
CALCULATE(
COUNT(Tasks[MilestoneType]),
FILTER(Tasks,Tasks[MilestoneType]="QIC - User Story" &&
Tasks[Task % Complete]=1)),
0
), "£#,##0.00,,K;(£#,##0.00),,K") & Newline &
"Avg Story spend" & Newline & "this Financial Year"
Is there a way to
Thanks for the help so far, this is proving to be more complex than I first thought, but it's a learning curve 😁
Fred
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
116 | |
102 | |
78 | |
76 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |