Forum Discussion

Emmy66's avatar
Emmy66
Helper V
2 years ago

Multi value selection from slicer

Hi, I'm struggling to wrap my head around this. Any help will be appreciated.   I have a report which uses measures that requires user input from from 2 different slicers as shown below.  ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Emmy66 ,

Please have a try.

Create a measure.

VAR vDate = MAX(Calendar[CY Date])
VAR vYear = YEAR(vDate) - 1
VAR vQtr = VALUES(Calendar[quarter])

RETURN
CALCULATE(
    [Amount],
    FILTER(
        FactTable,
        FactTable[Year] = vYear && FactTable[Quarter] IN vQtr
    )
)

 

How to Get Your Question Answered Quickly - Microsoft Fabric Community

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

 

Emmy66's avatar
Emmy66
Helper V
2 years ago

Anonymous Thanks for your response, which I appreciate a lot. The proposed solution is same with what I tried earlier which didn't work. I've attached a pbix file Multiselect.pbix with the required details and the result of the query too. Any help on this will go a long way. Thanks in advance