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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Computing the difference between visually filtered values

Hello!

I would like to know if there is a way to calculate the diffrence betwenn two values that are being visually filtered.
The situation is as follows:
Currently, my dashboard is composed of two sides (left and right). I have the exact same measures being displayed on a multi row card on each side, but each side is being affected by its own filters. Meaning that I have 3 slicers on the right only interacting with the card on the right and 3 slicers on the left only interacting with the card on the left.

Just for better understanding, those slicers could be filtering YEAR, MONTH and TYPE, and the idea of this report is to compare the same measure evaluated on a specific period and category with another period and category. 

My question now is: How could I have a visual (lets say on the middle) that is displaying the difference between the value on the right and the left?

Thanks for your help in advance! 🙂

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , Refer these two examples

 

Power BI How to use/compare two Date/Period slicers: https://youtu.be/WSeZr_-MiTg

Compare Categorical Data Using Slicers, Compare Two Brands/Categories/Cities: https://youtu.be/exN4nTewgbc

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors