Forum Discussion

baneworth's avatar
baneworth
Icon for Helper III rankHelper 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
Icon for Community Support rankCommunity 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
    Icon for Super User rankSuper User
    6 years ago

    baneworth you can redact your data and share it thru onedrive

      • v-gizhi-msft's avatar
        v-gizhi-msft
        Icon for Community Support rankCommunity 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