How to Filter Gallery by Quater and cover thaht filter under button ?

[Bartdzb]

Hello All, 

Can anyone show me the way how I can create a button that, when pressed, will filter the data, divide records into quarters, i.e. 4 buttons Q1, Q2, Q3, Q4 after pressing the Q1 button in the gallery there will be records only with the date from quarter 1

I will be grateful for every idea. 

[WarrenBelz]

Hi @Bartdzb ,

Assuming your quarters start in January, if you put this in your Gallery Items (note YourDataSource includes what is there presently) and you will have a field to filter on - just set varQuarter on the buttons

Filter(
   AddColumns(
       TestFields,
       "Quarter",
       RoundUp(
          (Month(DateTest) + 1) / 4,
          0
       )
   ),
   Quarter = varQuarter
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps