How to use dax measure in legend field of stacked bar chart

[sivarajan21]

Hi,

I am confused about how to use measure in legend colum.

@Ahmedx & @lbendlin helped me to create this  beautiful measures:

Accrual Source =
SWITCH (
TRUE (),
'Missing Calendar date_1'[Profile_efficient measure] <> BLANK (), "Profile",
'Missing Calendar date_1'[Direct_not efficient measu] <> BLANK (), "Direct",
'Missing Calendar date_1'[Target Unit] <> BLANK (), "Target",
'Missing Calendar date_1'[Half hour] <> BLANK (), "Half hour",
'Missing Calendar date_1'[Water] <> BLANK (), "Water"
)

But i am not able to drag this into legend column of stacked bar chart. Because of that chart shows like below(doesn't each source).

I need to show in chart which source data come from that is Profile or Direct or Target.

Please find sample file in below link:

Missing Calendar fixed.pbix

The expected outcome for legend is:

Please let me know if you need further details

Thanks in advance

@Ahmedx  @lbendlin @grantsamborn @Greg_Deckler @Ashish_Mathur 

[Ashish_Mathur]

Hi,

I could drag that field to the legend.  See image below.  The month order is not correct but that was not your problem in the first place.

[sivarajan21]

Hi @Ashish_Mathur ,

The field you have dragged is from Missin Calendar table which should work.

But my question is I was not able to drag measure Accrual_Source in visual legend

Thanks

[Greg_Deckler · Accepted solution]

@sivarajan21 In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...

[sivarajan21]

Hi @Greg_Deckler ,

Thanks for this amazing article

Surely I will try this and get back to you if any issues

Now I will accept this as a solution

Many Thanks