Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Filtering results on X Axis

Hi,   New to PowerBI so apologies if this should be obvious.   If I have the following data: Fiscal YQ table   YQ rownum 2020 Q 4         1 2020 Q 3         2 2020 Q 2         ...
Need Help
  • AllisonKennedy's avatar
    AllisonKennedy
    5 years ago
    If you want this to work for all YQ then you need to use YQ in the ALLSELECTED:

    QuarterSelectBounds = ((CALCULATE(MIN('AnalysisFiscalYearQuarterSort'[rownum]),ALLSELECTED(AnalysisFiscalYearQuarterSort[YQ]))+3))
AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
5 years ago
If you want this to work for all YQ then you need to use YQ in the ALLSELECTED:

QuarterSelectBounds = ((CALCULATE(MIN('AnalysisFiscalYearQuarterSort'[rownum]),ALLSELECTED(AnalysisFiscalYearQuarterSort[YQ]))+3))