Forum Discussion

baneworth's avatar
baneworth
Helper III
6 years ago

Target Line on combo graph

Having difficulties finding a DAX which works   I have Targets for Q1,Q2,Q3,Q4 and many different products     I created Slicers for Product (only one product shown at a time), Month and Y...
Need Help
v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

Thank you for sharing your file.

I extract some data to create a simple sample to test:

Please try to unpivot the four Quater columns:

After Apply&Close, Choose [Attribute] as X-axis and [Product] as Legend and [Value] as Value:

When you select one product, it shows:

Hope this helps.

 

Best Regards,

Giotto Zhi

  • baneworth's avatar
    baneworth
    Helper III
    6 years ago

    Thanks for your input Giotto but i am afraid i cant use it like that, as you maybe saw in the sample file i have to attach the Quarter targets to the already created "Line and stacked column" chart as the Line value.

     

     

    Best regards