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
syzygyamteam
New Member

How to remove page filters from in-text value

Hi everyone,

 

I am trying to show a generation vs forecast percentage using powerbi but drawing from a seperate spreadsheet. 

 

On the page, I want to be able to show the SUM(tbDailyOutputSummary[TGM Output (kWh)])/SUM(tbDailyOutputSummary[Business Case Target (kWh)]) for a specific period as well as a to date summary.

 

At the moment, the page filters specify just the period, therefore the formula does not allow me to show a to date percentage.

 

It is not a measure, which I have seen how to use and have been able to get the correct figure using that method, however, this I can only present as a visual rather than an in-text formula.

 

If someone could help me with this I would be grateful.

 

Best regards,

1 REPLY 1
Anonymous
Not applicable

Hi  @syzygyamteam ,

 

It's not clear what you mean, are you trying to display the data so far unaffected by the page filter

Measure=
SUMX(
    FILTER(ALL(tbDailyOutputSummary),
    'tbDailyOutputSummary'[Date]>=DATE(YEAR(TODAY()),1,1)&&'tbDailyOutputSummary'[Date]<=TODAY()),[summary])

 

You can use pictures to show the results you want, and we can help you better

 

This is the related document, you can view this content:

Solved: Stop Page Level Filter From Applying to One Visual - Microsoft Power BI Community

Solved: Need one Visual to ignore a Page Filter - Microsoft Power BI Community

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

Top Solution Authors