Forum Discussion
Area Chart Interactions
I have an area chart which shows target sales and actual sales against month. The targets table has the columns: Team Month Target Whilst the sales table has the columns: SaleID SaleDate...
ankitpatira thanks for the reply. I tried your DAX and it resolves the filtering issue but fixes the annual target value as target for each month. Using ALL('YOURTABLE'[targetColumn]) instead of ALL('YOURTABLE') resolved this but the filtering reverts back to my original problem.
Any ideas?
Hi kmcd,
Could you please share sample data of your tables and post the expected result here? We will appreciate that if you can share the PBIX file.
Thanks,
Lydia Zhang