Hi!
I have a table data displaying YoY difference between two years, i.e. This year and last year which is defined in the formulas. There are two line charts below this table , one displaying the Last year's Transaction for the companies and the second one for tihs years companies.
What I am trying to achive: To be able to not restrict the report to just "This Year" and "Last Year", the report should be able to provide selections via a slicer to enable selecting any year I want to see on these two charts and based on the selction of the Year on charts the table above these charts displaying YoY values dynamically chnage. Currently it is restricted to "This Year" i.e. 2019 and "Last Year" i.e. 2018 and I am not able to select or chnage years. Even if I put individual slicers for each line chart which works fine on the charts , but the YoY values on the tavble above does not reflect that YoY values.
Help will be greatly appreciated.
I want to be able to select any year on those two individual charts and the table above should refrelct the YoY based on the Years selected on the teo line chart's below.
Please find attached the .pbix file.
Kind Regards
