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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
bopeh_99
Frequent Visitor

Calculate % change based on slicer (not date format)

Hi! I'm trying to create a measure to calculate the % change of value based on my slicer selections (which is not in date format). 

 

Here's the sample of my data. My slicer will be "Semester" and I would like to calculate the difference between value based on the selected semesters (up to all of them). For example, if i select semester AH2019 and AH2021, it will show -8% decrease. if i select AH2019, AH2020, AH2021, it will show the % change between all 3 semesters (18.57%, -22%). 

Semester Value% difference 
AH 20197000 
AH 20208300 
AH 20216400 
SS 201910200 
SS 202018202 
SS 2021 8100 

 

Please kindly assist. Your help is much much appreciated.

4 REPLIES 4
Ahmedx
Super User
Super User

Please check if these results are correct.
Screen Capture #775.pngScreen Capture #776.pngScreen Capture #777.png

Hello! Yes! Similar. I am trying to show something like this and would like to add the formula for the percentage change. 

bopeh_99_0-1680493084830.png

 

Ahmedx
Super User
Super User

can you explain in detail how you got it -8%
what was taken away and what was divided.
show in numbers how it turned out -8%

-8% is (6400/7000)-1, the difference between just AH2021 and AH 2019, where 2021 is the newer value based on the year

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

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.