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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

filter page to only show year to date value for the month so we do not see the months with no values

Hi all,

 

Is there a way to Add a filter to a page to only show year to date value for the month so we do not see the months that do not have values ?

Would I need to create a measure to drop into the page filter?

Does any one have an sample PBIX files are measures to share with me for this problem?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

How Can I create a measure for a page level filter so that for all my tables which months of data I the filter does not show those months

 

HarryB_1-1712161240160.png

Something like this should work but I can not get it to work.

 

YTD_CurrentMonth_Value =
VAR CurrentMonth = MONTH(TODAY())
RETURN
CALCULATE(
[YourMeasure],
FILTER(
ALL('Date'[Month]),
'Date'[Year] = YEAR(TODAY()) && 'Date'[Month] <= CurrentMonth
)
)

 

If someone has a PBI file to share or some code that would be helpful

 

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

How Can I create a measure for a page level filter so that for all my tables which months of data I the filter does not show those months

 

HarryB_1-1712161240160.png

Something like this should work but I can not get it to work.

 

YTD_CurrentMonth_Value =
VAR CurrentMonth = MONTH(TODAY())
RETURN
CALCULATE(
[YourMeasure],
FILTER(
ALL('Date'[Month]),
'Date'[Year] = YEAR(TODAY()) && 'Date'[Month] <= CurrentMonth
)
)

 

If someone has a PBI file to share or some code that would be helpful

 

kpost
Super User
Super User

Perhaps you could include screenshots of an excel file or your .pbix file showing the current situation versus what you want?  In other words, what do you have now, and what do you want the solution to look like? 

 

Please provide as much information as you possibly can, including a screenshot of your data model, the measures you have already created as well as describing the ones you want us to help you create, to increase the chances someone will be able to answer your question.  

 

More information is almost always better on this forum.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.