Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
rlsmith1994
Helper II
Helper II

calculate difference between two tables in two charts

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. It's pretty easy in Excel and Tableau, so there's got to be a simple method for Power Bi. 

 

Thank you.

 

nssefssepic.JPG

0 REPLIES 0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.