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
ACraig08
Helper III
Helper III

Creating a Dynamic Value within a Text Box that has filters

So I have a table that has a filter on it for which quarter we are looking at. In this case Q3. I have a measure that calculates the percent difference between two columns called Let Total Percent Difference. I was trying to create a dynamic value in my text box that shows the Let Total Percent Difference for Q3. The variable that holds the quarters is called MFB Quarter. 

 

Table name = project data

MFB Quarter = Q3

value to show = total percent difference

 

When I do the calculations manually they should be 10.96% but this is what is gives me.

ACraig08_0-1689799654760.png

I can't for the life of me figure out how to do this. It has this part where it talks about filters and slicers affecting the value but it doesn't have a way to add any.

ACraig08_0-1689799913001.png

 

I have tried to look an answer up but no luck. 

 

PLEASE HELP!

 

1 REPLY 1
amitchandak
Super User
Super User

@ACraig08 , I am assuming you have measure QOQ change % and you are using that

 

example

QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(('Date'[Date])))
Last QTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESQTD(dateadd('Date'[Date],-1,QUARTER)))

 

QOQ % = divide([QTD Sales]-[Last QTD Sales],[Last QTD Sales])

 

Power BI — Qtr on Qtr with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
https://www.youtube.com/watch?v=8-TlVx7P0A0

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
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!

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
Top Kudoed Authors