Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a month slicer pointing to Date[Monthshort] in my Date table. This shows the 3 letter month name. It is currently showing all 12 months. I am using a calculated column called "IsLastSixMonths" to determine if the date in Dataset[ContactDate] is in the last six months. This results to True/False and updates dynamically based on today's date. I have this as a filter on the page visual, and everything else on the page is filtering correctly. How can I get my filter visual to only show the six month window?
Solved! Go to Solution.
@joshcomputer1,
In your scenario, create the calculated column in the Date table instead of the DataSet table, then drag the calculated column to page level filter, this way, the month slicer will be filtered correctly.
IsLastSixMonth1 = VAR MonthDiff = IF ( 'Date'[Date]<= TODAY (), - DATEDIFF ( 'Date'[Date], TODAY (), MONTH ), DATEDIFF ( TODAY (), 'Date'[Date], MONTH ) ) RETURN IF ( MonthDiff >= -6 && MonthDiff <= -1, TRUE () )
Regards,
Lydia
@joshcomputer1,
In your scenario, create the calculated column in the Date table instead of the DataSet table, then drag the calculated column to page level filter, this way, the month slicer will be filtered correctly.
IsLastSixMonth1 = VAR MonthDiff = IF ( 'Date'[Date]<= TODAY (), - DATEDIFF ( 'Date'[Date], TODAY (), MONTH ), DATEDIFF ( TODAY (), 'Date'[Date], MONTH ) ) RETURN IF ( MonthDiff >= -6 && MonthDiff <= -1, TRUE () )
Regards,
Lydia
I test the scenario as yours and can’t reproduce your issue. I create the calculated column using the DAX below, and put it to page level filter and set its value to True, the month slicer is filtered correctly.
IsLastSixMonths = VAR Datediff = 1 * ( 'Calendar'[DateKey] - TODAY () ) RETURN SWITCH ( TRUE, AND ( Datediff <= 0, Datediff >= -180 ), TRUE(), Datediff < 180, FALSE() )
Would you please share your PBIX file for us to analyze? You can upload PBIX file to OneDrive, and send me the shared link of the PBIX file via Private message.
Regards,
Lydia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |