Forum Discussion
Solved
Select Month based on Year Selection from Slicer
I have two slicers - Year and Month. 1st line chart: shows Month wise sales for the selected year 2nd line chart: shows daily sales based on selection of year and month. A message is displayed if m...
Hi all,
Solved it! Thanks all for your help!
Below is what I did.
Filtered Months = ISFILTERED('Calendar'[Month])This will check if Month is selected or not and return True / FalseFor values measure:Daily_Final_ = IF([Filtered Months] = FALSE(),CALCULATE('Calculations'[Total_Yield],'Calendar'[Month_No] = MONTH(NOW())),'Calculations'[Total_Yield])This gives me current month values if month is not selected.Now if i select Year and month is not selected, it gives me current month values.I have removed the month slicer and allowing the user to select month from the 1st line chart which displays month wise details.
Hi all,
Solved it! Thanks all for your help!
Below is what I did.
Filtered Months = ISFILTERED('Calendar'[Month])
This will check if Month is selected or not and return True / False
For values measure:
Daily_Final_ = IF([Filtered Months] = FALSE(),CALCULATE('Calculations'[Total_Yield],'Calendar'[Month_No] = MONTH(NOW())),'Calculations'[Total_Yield])
This gives me current month values if month is not selected.
Now if i select Year and month is not selected, it gives me current month values.
I have removed the month slicer and allowing the user to select month from the 1st line chart which displays month wise details.