Forum Discussion
Helper IVConditional measures to use as slicer selection
Hi All,
Please suggest measure to create slicer based on below condition (which i would like to use across different pages of dashboards)
If period_ind = 2 then ‘Current period ‘
If period_ind = 1 then ‘Previous period ‘
Dataset sample:
Thank you.
Hi , how about keeping it very simple and create a calculated column ?
Column = IF('Table'[period_ind] = 1, "Previous period", IF('Table'[period_ind] = 2, "Current period", BLANK()))
4 Replies
- Akash_Varuna
Super User
Hi Snagalapur Try this please
Measure for Dynamic Selection:
For a slicer that dynamically updates measures (like Sum of Actual or Sum Of Budget):
Selected Period = SWITCH( TRUE(), MAX(Data[period_ind]) = 2, "Current Period", MAX(Data[period_ind]) = 1, "Previous Period", BLANK() )Then, add this measure to your slicer to filter your visuals dynamically.
You can remove the SUM if you dont want to pick up on Sum of Actual or Sum of Budget
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
SnagalapurThank you for details, I'm unable to add details into Slicer could you please suggest (as slicer measure doesnt split values into Current and Previous period ex mentioned below)
- kushanNa
Hi , how about keeping it very simple and create a calculated column ?
Column = IF('Table'[period_ind] = 1, "Previous period", IF('Table'[period_ind] = 2, "Current period", BLANK()))
