Forum Discussion
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
- Akash_Varuna
Super User
Hi AMitchell Could you check this please
Create a Measure for Percentage Difference:
Percentage Difference = DIVIDE( [February Value] - [January Value], [January Value], 0 ) * 100Add 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
- AMitchellFrequent 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)RETURNIF(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:
- NotanExpertFrequent 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.