Target Line on combo graph

Question

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 Year.

Product column from this table is linked to Main Table(used for chart).

What i am trying to do now is, once i select a product it should show the correct Target as a line (Best case scenario with correct Quarter as well). I am also fine with 1 quarter setup only and change them manually once the quarter is done.

I am struggling with the correct DAX for this

Best regards and thank you

parry2k · Answer

baneworth&nbsp;I'm sure it is doable but it will be much easier if you can provide a sample pbix file with your data (remove sensitive info before sharing), it will help to provide the solution.

baneworth · Answer

Thanks for taking the time to respond&nbsp;https://lamresearch-my.sharepoint.com/:u:/p/matthias_wrolich/EWLPYmZ8BUBEswjzUckmge4BwUJAOHfwQ3OlnvehDVJiqA?email=Matthias.Wrolich%40lamresearch.com&amp;e=Dt9akQ&nbsp;Please let me know if this Link works for you&nbsp;The data tables providing data for this problems are "Target" &amp; "vwLPR"&nbsp;Best regards

v-gizhi-msft · Answer

Hi,&nbsp;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?&nbsp;Best Regards,Giotto Zhi

parry2k · Answer

baneworth&nbsp;you can redact your data and share it thru onedrive

baneworth · Answer

That should do it&nbsp;https://1drv.ms/u/s!AuYSFePTjcs5khhDalNPb0iEivGi?e=Urc93u&nbsp;sorry, it is the first time i make use of it

Forum Discussion

Target Line on combo graph

7 Replies

Related content

Combo chart with target line

Creating Cumulative Graphs

Combo Graph & Date Alignment

Changing Target Value in SPC Graph

Combo column chart with target lines