Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a matrix visual that I would like the title to dynamically change based on the current month selected on the screen.
Alternatively if there are no month selections than the title should just show the Previous Month YTD as a title as the data set is in line with this range.
I have created a measure :
Solved! Go to Solution.
Hi @nh27 ,
I have create a simple sample, please refer to it to see if it helps you.
Please create a measure.
Measure =
VAR Previous_Month =
DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) - 1, 1 )
VAR _value =
CALCULATE (
MAX ( Sheet4[value] ),
FILTER ( ALL ( Sheet4 ), Sheet4[date] = Previous_Month )
)
VAR _aa =
CALCULATE (
MAX ( Sheet4[value] ),
FILTER ( ALL ( Sheet4 ), Sheet4[date] = SELECTEDVALUE ( 'Table'[Date] ) )
)
VAR _result =
IF (
MAX ( Sheet4[value] ) = _value
&& MAX ( Sheet4[date] ) = Previous_Month,
_value,
BLANK ()
)
VAR __resulttrue =
IF ( MAX ( Sheet4[date] ) = SELECTEDVALUE ( 'Table'[Date] ), _aa, BLANK () )
RETURN
IF ( ISFILTERED ( 'Table'[Date] ), __resulttrue, _result )
If I have misunderstood your meaning, please provide more details with your desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @nh27 ,
I have create a simple sample, please refer to it to see if it helps you.
Please create a measure.
Measure =
VAR Previous_Month =
DATE ( YEAR ( TODAY () ), MONTH ( TODAY () ) - 1, 1 )
VAR _value =
CALCULATE (
MAX ( Sheet4[value] ),
FILTER ( ALL ( Sheet4 ), Sheet4[date] = Previous_Month )
)
VAR _aa =
CALCULATE (
MAX ( Sheet4[value] ),
FILTER ( ALL ( Sheet4 ), Sheet4[date] = SELECTEDVALUE ( 'Table'[Date] ) )
)
VAR _result =
IF (
MAX ( Sheet4[value] ) = _value
&& MAX ( Sheet4[date] ) = Previous_Month,
_value,
BLANK ()
)
VAR __resulttrue =
IF ( MAX ( Sheet4[date] ) = SELECTEDVALUE ( 'Table'[Date] ), _aa, BLANK () )
RETURN
IF ( ISFILTERED ( 'Table'[Date] ), __resulttrue, _result )
If I have misunderstood your meaning, please provide more details with your desired output.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi
It depends on how you've setup your table, but you can do something with this logic:
Measure 2 =
IF(
DISTINCTCOUNT('Calendar'[Month]) =1,
MIN('Calendar'[Month]),
--Place below the option if none is selected
)
Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |