I am trying to represent a combined bar and line graph, showing revenue as the bar graph and each expense type as a line graph. The idea to see where expenses visually are above revenue, the problem is when i try and filter on the pivot or via the slicer the expense type the entire graph returns to a bar graph as per Graph 2.
Please help and advise how i overcome this problem.
Please help and advise how i overcome this problem.