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.
Hi ,
I using two slicer, one for year and another one for month, if i select 2021 year, the month slicer only have to show upto october month, because 2021 November and december values(Sales) not added. Kindly advice how to create a slicer while select 2021 year and month upto october.
Solved! Go to Solution.
Hi @NavaneethaRaju ,
You can create a measure like this, put it in the month visual filter and set its value as 1:
A =
IF (
SELECTEDVALUE ( 'Table'[Date].[Year] ) = YEAR ( TODAY () ),
IF ( MAX ( 'Table'[Date].[MonthNo] ) <= MONTH ( TODAY () ), 1, 0 ),
1
)
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @NavaneethaRaju ,
You can create a measure like this, put it in the month visual filter and set its value as 1:
A =
IF (
SELECTEDVALUE ( 'Table'[Date].[Year] ) = YEAR ( TODAY () ),
IF ( MAX ( 'Table'[Date].[MonthNo] ) <= MONTH ( TODAY () ), 1, 0 ),
1
)
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @v-yingjl ,
I'm getting error, using now.
And one thing in your measure You used the column [monthNo], that is not in your table. please check and advice.
Your Measure.
Your table.
Create the following Measure :
This gives only those months have sales in your Sales Table.
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Create a measure with this code:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |