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,

 

Due to community security policy, I'm unable to sign in your link by my personal account.
In order to solve your issue, could you please share the file via OneDrive for Business?
 
Best Regards,
Giotto Zhi
parry2k's avatar
parry2k
Super User
6 years ago

baneworth you can redact your data and share it thru onedrive

    • 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