Displaying difference between two charts based on different tables

rlsmith1994 — Thu, 02 Apr 2020 17:59:33 GMT

I have two charts from two tables that ask similar questions, one for teachers (red) and the other students (blue). I am asking for help to help show the difference between the two charts (I am new to power bi, but have used Tableau for years). I think there are two ways to do this:

1. A table or chart displaying the difference between the values. For example, the first bar line difference is -2% (red 55% minus blue 57%), the second bar line difference is -17% (red 51% minus blue 68%), and so forth.

2. A chart that would display the red bars right next to the blue. I think this is sufficient to highlight the differences (as opposed to a calculated value)

I am not picky about the visual that would display the difference itself; it can be a card, table, chart, or whatever. I am just looking for a simple way to display the difference.

Thank you.

topic Displaying difference between two charts based on different tables in Report Server

Displaying difference between two charts based on different tables