Forum Discussion
Formatting Date for Matrix columns
Hi,
I formatted my dates for the Date Column in this Format already "(ddd) dd.mm" and it works, but I want to add a line break after the ")". So that i looks like this :
But I can not seem to add a line break in the formatting neither with a unichar(10) nor <br>.
I thought about formatting the width of the column header but since it is already bigger than the value it doesnt work.
I also dont want to set every column width individually since the date table contains values for multiple years.
Do you guys have any suggestions how to solve this?
Hi Knegge ,
lbendlin Thanks for your concern about this case!
And Knegge , Power BI does not yet support adding line breaks to achieve your desired results. If you want your data to have line breaks after ), you can either enter the line breaks as you enter the data:At this time, the line break effect will not be reflected in the Table view:
but when you put the data into the visual object, you can reflect the effect of line breaks:
Either that or you'll have to turn on Text wrap in Settings and manually set the width of each column, which you mentioned you don't want to do manually, but perhaps you'll have to with the current functionality:
Then again, as lbendlin said, please post your idea here and vote for it, and maybe sometime in the future your idea will be adopted and this feature will be realized.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hi Knegge ,
lbendlin Thanks for your concern about this case!
And Knegge , Power BI does not yet support adding line breaks to achieve your desired results. If you want your data to have line breaks after ), you can either enter the line breaks as you enter the data:At this time, the line break effect will not be reflected in the Table view:
but when you put the data into the visual object, you can reflect the effect of line breaks:
Either that or you'll have to turn on Text wrap in Settings and manually set the width of each column, which you mentioned you don't want to do manually, but perhaps you'll have to with the current functionality:
Then again, as lbendlin said, please post your idea here and vote for it, and maybe sometime in the future your idea will be adopted and this feature will be realized.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi Anonymous,
the Problem is not that the values in the matrix cant be formatted, but the column headers cant be formatted with a line break.
Is that not possible aswell?
Regards KneggeHi Knegge ,
Column headers are the same as values, it cant be formatted with a line break.
As I said before, you can either wrap the data as you enter it, or you can change the column width manually.
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com/?forum=2d80fd4a-16cb-4189-896b-e0dac5e08b41
