Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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?
Solved! Go to Solution.
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
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
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
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
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
146 | |
72 | |
63 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |