Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Add enter space in measure

Hi,

Data lable-Detail values not shonw fully due to bars so is there any way to put Enter space to move the values up?

& UNICHAR(10) doesn't work at measure. and we cannot have 2 text sizes 
 

Pls see my measure at the bottom.

 

 

Measure =
    VAR
        _difference = [vs Last Week]
    VAR
        _direction =
            SWITCH(
                TRUE()
                , _difference > 0, "▲"
                , _difference < 0, "▼"
                , "-"
            )

    VAR
        _direction2 =
            SWITCH(
                TRUE()
                , _difference > 0, "+"
                , "-"
            )
    VAR
        _percentchange =
            _difference / [Last Week Count of $dn]
    RETURN
        _direction & " " & _difference & " (" & _direction2 & FORMAT(_percentchange, "###.##%") & ")" & UNICHAR(10)
General Comment
Need Help
Show and Tell
Tips and Tricks

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, Anonymous 

    After my testing, unchar(10) only works when heading, as shown in the image below:

    Measure 2 = ","& UNICHAR(10)&"    "&UNICHAR(100)

    I put this measure in the title of the card along with the card, as shown in the image below:

    When I turn off the text wrap function, I successfully implement line wrapping via unchar(10), as shown in the image below:

    Using unchar(10) in places other than the title does not allow for line breaking.

    You can change the layout to a single line as shown in the image below:

    In addition, you will need to adjust the range of the Y axis, which is shown as follows without the adjustment range:

    After adjusting the range, the data label will be displayed at the top of the chart, and then you will be adjusting your data label font to match the detail font

     

     

     

     

     

    How to Get Your Question Answered Quickly

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

    Best Regards

    Jianpeng Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.