How to compare different years date in a single table and chart
Hi I am trying to create a report from the responses to a travel survey and need to be able to compare results from last year against those for this year. Specifically I need to be able to show in one chart the changes in the amount of CO2 produced by various modes of transport from one year to the next. I have tables for the journey data for both last year and this year with a measure that calculates the CO2 figure for the different modes of transport. The fields in both tables are the same. At the moment the results of the calculation run through the measure are shown as two separate graphs in the report whereas it would be visually better to have them as a single graph. How would I combine the two years worth of data to show the different CO2 emissions for each mode of transport as a single graph? As the survey that gathers the journey data is run ever year it would be good to be able to understand how to do this so that the changes over a longer period of time can also be shown if required. Any help with this would be most welcome. Many thanks, Andy
Selected Year Side By Side Comparison In chart
Hi guys, I want to create a bar chart or any other chart that will include loss ratio data from two selected years. (for example, if i choose 2020 and 2022 it has to show both of them side by side). The problem is when I create a single date slicer and choose both years there's no side by side comparison, it's just a dynamic visualization of it (as first screenshot shows). I want them to be side by side like next to 2019 qtr1 has to be second chosen year's first quarter results like its on the second screnshot. Loss ratio means Loss Amount divided by Sales Amount.
