Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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,
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.