Percentage change when having legend in a stacked bar graph

[MuthalibAbdul]

The first visual is what Im getting while the second is what Im trying to achive plus the stackkked categories. 

The first visual is a stacked bar graph where the locations are denoted by different color. Im trying to do a week over with percentage change. This works fine when I do not add a column or field in the legend section. However, once I add a legend, the percentage difference is calculated by every location which is not what I want. I still want the bars to show different colors for each location, but want the percentage diff shown on the top. I have pasted all the 3 measures Im using to get the result. But somehow want the measures to show up on top of the bar while also exclude the Location column

PW Encounters =

VAR MaxDate = MAX('Calendar'[Date])

// FIX: Use WEEKDAY(..., 1) for Sunday start

VAR WeekStart = MaxDate - WEEKDAY(MaxDate, 1) + 1  // Changed from default to 1

VAR PreviousWeekStart = WeekStart - 7

VAR PreviousWeekEnd = PreviousWeekStart + 6

RETURN

CALCULATE(

    [Total Encounters],

    FILTER(

        ALL('Calendar'),

        'Calendar'[Date] >= PreviousWeekStart &&

        'Calendar'[Date] <= PreviousWeekEnd

    )

)

WeekDiff =

VAR PrevWeek = [PW Encounters]

VAR CurrWeek = [Total Encounters]

RETURN

IF(

    ISBLANK(PrevWeek),

    BLANK(),

    CurrWeek - PrevWeek

)

WoW%withsigns =

VAR _WoW =

DIVIDE(

    [WeekDiff], [PW Encounters] )

RETURN

FORMAT(

    _WoW,

 "▲ 0%;▼ 0%")

[v-veshwara-msft]

Hi @MuthalibAbdul ,

We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out.
Thank you.

[v-veshwara-msft]

Hi @MuthalibAbdul ,

Thanks for reaching out to Microsoft Fabric Community.

Just wanted to check if the responses shared were helpful. If further assistance is needed, please reach out.

Also as noted by @d_m_LNK, it would be useful to confirm where the measure is applied on the visual, as data label behavior can depend on how the measure is added and formatted.

Additionally if the scenario discussed by @danextian matches your requirement, please consider upvoting the issues link to help bring more visibility to this enhancement request.

If you need any further clarification, please let us know.

Thank you.

[MuthalibAbdul]

This actually worked partially. However, how do I add the percentage change on top of the bar and not for each category in the bar? Thanks

[danextian · Accepted solution]

Hi @MuthalibAbdul 

There’s currently no way to use a custom field for the total label. Another approach would’ve been to use a line chart and label the lines instead—but even though line charts appear to support custom data labels, it doesn’t actually work in practice (switching to a different measure doesn’t change anything). Please vote for this issue: https://community.fabric.microsoft.com/t5/Issues/Combo-chart-custom-data-label-for-line-chart-not-ma...

So the workaround is to identify which series will always sit on top, then enable data labels only for that series. On top of that, a separate measure is needed to calculate the total across all series.

I used these measures for the image below:

Revenue All Geos = 
CALCULATE ( [Total Revenue], ALL ( Geo ) )

Revenue MOM = 
VAR _prev =
    CALCULATE ( [Revenue All Geos], PREVIOUSMONTH ( Dates[Date] ) )
VAR _diff = [Revenue All Geos] - _prev
RETURN
    DIVIDE ( _diff, _prev )

Would have been better if there was an option to add the data label outside the series but it also isn't available. 

[d_m_LNK]

Where do you have that measure applied to the visual?  It's most likely a formatting issue but can't tell where the measure is added.

[d_m_LNK]

The last measure you specified is going to follow the filter context so that's why each location is evaluated separately.  You could try this for your measure:

WoW%withsigns =

VAR _WoW =

CALCULATE(

DIVIDE(

    [WeekDiff], [PW Encounters] ),

ALLSELECTED(Locations[Locations])

)

RETURN

FORMAT(

    _WoW,

 "▲ 0%;▼ 0%")