Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have created one measure using below formula for maximum month items
=count({<Flag={1}, Closed_MonthSerial= {"$(=Maxstring([Closed_MonthSerial]))"}>}Item_Id)
i want to show Label name as 'july month items' instead of current month
how to do that
You can change it data Label field
use this
=Closed_MonthSerial&' '&'month items'
Thanks for reply
unfortunately i have used It is giving - null value
if its not working then you need to check your month field in the calendar.
you might find the issue. as it showing null value there must be an issue with the month field.
You can follow the steps..
1. Create a variable called Variable Overview and that holds the label name for the selected month.
ex:
LET vLabelName = 'July month items';
2. Modify your expression to use the variable in the label instead of the static text
=count({<Flag={1}, Closed_MonthSerial= {"$(=Maxstring([Closed_MonthSerial]))"}>} Item_Id) as [$(vLabelName)]
Therefore
You are dynamically setting the label name to the value stored in the variable vLabelName.
I hope it help you.