Forum Discussion

AMitchell's avatar
AMitchell
Frequent Visitor
1 year ago

Data Label to show percentage difference between two columns

Hi

 

I'm trying to have a data label on this chart to show the percentage movement between the two columns. I have a measure that calculates the difference set up.

I would like the 0.27% difference above the February 2025 column if possible.

 

Thanks

3 Replies

  • Hi AMitchell Could you check this please 

    • Create a Measure for Percentage Difference: 

      Percentage Difference = DIVIDE( [February Value] - [January Value], [January Value], 0 ) * 100
    • Add the Measure as a Data Label:

      • Select your visual.
      • Drag the Percentage Difference measure into the "Values" field of the chart
        If this post helped please do give a kudos and accept this as a solution
        Thanks In Advance
  • AMitchell's avatar
    AMitchell
    Frequent Visitor

    My measure has to be fluid as the dates change:

    Say Value Change (Fund) =
    VAR LatestDate =
        CALCULATE(
            MAX(PropData[Valn Date])
        )
    VAR PreviousDate =
        CALCULATE(
            MIN(PropData[Valn Date])
        )
    VAR LatestValue =
        CALCULATE(
            SUM(PropData[Say Value]),
            PropData[Valn Date] = LatestDate
        )
    VAR PreviousValue =
        CALCULATE(
            SUM(PropData[Say Value]),
            PropData[Valn Date] = PreviousDate
        )
    RETURN
        IF(
            NOT(ISBLANK(LatestValue)) && NOT(ISBLANK(PreviousValue)),
            (LatestValue - PreviousValue) / PreviousValue,
            BLANK()
        )
     
    If i add this to the chart i get this:

     The format of the measure is set to percentage and when i show it in a card it's working:

     

  • NotanExpert's avatar
    NotanExpert
    Frequent Visitor

    It's a Bug.. a lot of users have the same Problem.. 
    In my case looks like this: 


    Workaround for the moment: Create Labels with FORMAT Strings and use them as Label..

    It's a joke to be honest.. 
    With the January update was the same problem after uploading it. In Desktop no Problem at all but after publishing the formating disappeared.