Legend setup help

[LaharshK]

Hello Community, 
I'm creating a stack area chart 
x axis: date
Y axis : Count of my LOQs 
my loq has L1 L2 L3 and blanks I've created below for each one of them. 

Count_L1 = 
CALCULATE(
    COUNTROWS('Issues'),
    'Issues'[Level_of_Quality_Fixed] = "L1"
)

Issues is that I'm not able to drag the Level of quality to Legend so that It shows me a datewise stack graph based on L1 to L3 and including the blanks. 

I converted the blanks to Unknown so that It should show me correct details 

Level_of_Quality_Fixed = 
COALESCE(
    SELECTEDVALUE('Issues'[Level_of_Quality]), 
    "Unknown"
)

Do anyone of you have any Idea what I can do in this case?

Thanks in advance!

[dharmendars007]

Hello @LaharshK , 

Could you please share the sample data with the visual image with expected result so that it will help us to check further on the same.

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[LaharshK]

I want to make something like this
Date I've created another table with many to 1 relation used on Xaxis
i've created the count as metioned above. 

[Sergii24]

Hello @LaharshK, are you working with measures? Only model columns (i.e. impotred through PowerQuery or "calculated columns") can be used in legend field. 

Good luck with your project!

[LaharshK]

Thanks for the reply 
I'm indeed working with MEASURES 
I've also created a calculated column 

Level_of_Quality_Fixed =

COALESCE(

    SELECTEDVALUE('Issues'[Level_of_Quality]),

    "Unknown"

)
L1 L2 L3 Blanks are the fields that I've

[Sergii24]

Do you have issues with placing calculated column as a legend of stack area chart? Please share the screenshots:

1. Screenshot of data view (where calculated column is defined) and its DAX code. Please copy paste few rows of your data so we can recreate the calculated column
2. Screenshot of canvas, where you have a area chart (with corresponidng values of X, Y axis)

Thanks!