Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Slicing Calendar Table based on multiple columns condition

Hi everyone, I have a calendar Table containing my dates and some calculated columns that allows me to easily filter by dates in DAX Measures. See table below (my dates are contiguous of course, i...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    For now I solved it by adding multiple slicers to my page where the user can choose one he wants and SELECT it

_AAndrade's avatar
_AAndrade
Resident Rockstar
2 years ago

Hi,

If I understood well, you can use parameter with all your measures for each period.
For example:
Measure_Parameter =

{
    ("Last Month", NAMEOF('Measure'[SALES LAST MONTH]), 0),
    ("Last 3 Month", NAMEOF('Measure'[SALES LAST 3 MONTH])), 1),
    ("Last 6 Month", NAMEOF('Measure'[SALES LAST 6 MONTH]), 2),
    ("Last Year", NAMEOF('Measure'[SALES LAST YEAR]), 3)
}

And after use a Matrix visual as you have in your example and use the parameter measure on the Values.
I think this could solve your problem. If you need any help, please let me know.
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Andrade,

That is supposing I want only the sales. Actually whatever the measure would be in my table i would like to filter my dates.
So in essence if we imagine a matrix table where the dates are in the column.
The slicer should ONLY filter these dates. 

Not sure that is clear