how to use the filter for this specific scenario

[sid24]

Excel data looks like this :

 Date         Value

2014-01	17859
2014-02	17139
2014-03	20157
2014-04	20268
2014-5	29875
2014-6	14300
2014-7	21327
2014-8	96901
2014-9	94945
2014-10	17946
2014-11	19473
2014-12	19301
2015-01	19076
2015-2	19751
2015-3	21152
2015-4	21759
2015-05	24343
2015-6	24346
2015-07	24611
2015-08	23132
2015-09	22198
2015-10	21665
2015-11	19960
2015-12	22032
2016-01	21584
2016-02	22317
2016-03	23461
2016-04	24139
2016-05	27339
2016-06	25703
2016-07	26986
2016-08	24559
2016-09	23220
2016-10	20687
2016-11	22508
2016-12	22404
2017-01	22257
2017-02	22490
2017-03	25714
2017-04	25816
2017-05	29699
2017-06	28171
2017-07	29925
2017-08	28149
2017-09	25810
2017-10	25742
2017-11	24525
2017-12	24005
2018-01	26169
2018-02	23973
2018-03	27888
2018-04	27680
2018-05	32204
2018-06	29251
2018-07	32033
2018-08	29009
2018-09	27451
2018-10	27671
2018-11	26528
2018-12	27308
2019-01	27832
2019-02	26993
2019-03	29888
2019-04	31260
2019-05	34132
2019-06	31879
2019-07	35002
2019-08	31668
2019-09	30451
2019-10	26972
2019-11	29588
2019-12	27782

And there are five categories for each month  given below:

1.) 19-25

2.) 26-35

3.) 36-45

4.) Above 45

5.) up to 18

I am not sure of how to create another filter for filtering the data as per the above given five categories. the same way I have created the slicer filter for filtering the data specific month wise. but I don't know how to set the data in an order to get it done for the same.

if anyone can guide me through this issue, it would be a great help.

sorry for the inconvenience, I am kind of new to this platform and power bi. what I am trying to achieve is to create another filter for filtering the data as per given below fields.

1.) 19-25

2.) 26-35

3.) 36-45

4.) Above 45

5.) up to 18

when I click on any of these five categories it filters the data as per that. they all have total values like given below, but I don't know how to put the data in an order to achieve the same. but this is not the right order of the data to achieve the same goal I have mentioned earlier as it will create the filter as per values not the fields like up to 18,19-25 and so on. how could I get it done to achieve the same?

    date           value    up to 18   19-25       26-35       36-45  above 45

2014-01	17859	2020	128118	46485	1909	62
2014-02	17137	1926	123214	44325	1857	57
2014-03	20155	2311	145140	51872	2161	73
2014-04	20126	2322	144633	51936	2309	68
2014-5	21987	2371	157326	57601	2510	67
2014-6	21430	2354	153599	55776	2500	71
2014-7	22132	2355	158181	58191	2518	82
2014-8	20690	2177	147199	54965	2470	90
2014-9	20494	2149	145809	54478	2417	92
2014-10	17946	1764	126293	49100	2231	72
2014-11	19473	2097	137990	52278	2300	72
2014-12	19301	2029	136307	52301	2286	90
2015-01	19076	2004	133872	52410	2384	98
2015-2	19751	2070	139211	53745	2403	84
2015-3	21152	2166	148602	58059	2613	85
2015-4	21759	2151	154115	58666	2582	78
2015-05	24343	2409	173369	64665	2915	75
2015-6	24346	2421	173178	65013	2773	82
2015-07	24611	2415	174149	66549	2909	95
2015-08	23133	2381	162366	63667	2820	89
2015-09	22198	2292	155187	61580	2832	92
2015-10	21665	2267	152010	59577	2720	84
2015-11	19960	2136	139156	55590	2629	89
2015-12	22034	2432	153865	61195	2746	86
2016-01	21582	2298	149667	60925	2825	127
2016-02	22317	2305	155741	62080	2926	118
2016-03	23461	2336	161634	67409	3132	108
2016-04	24130	2424	167349	68281	3219	117
2016-05	27339	2838	190007	76832	3613	107
2016-06	25703	2502	178677	72353	3385	117
2016-07	26986	2626	187269	76278	3563	129
2016-08	24559	2301	168406	71428	3325	132
2016-09	23220	2238	159264	67485	3092	130
2016-10	20687	1994	140658	61104	3007	112
2016-11	22508	2184	153079	66466	3234	126
2016-12	22400	2318	152225	66267	3109	121
2017-01	22257	2125	150467	66584	3257	143
2017-02	22491	2126	151522	67807	3301	145
2017-03	25716	2336	173163	77609	3899	139
2017-04	25816	2389	174758	77121	3760	141
2017-05	29699	2693	201945	87977	4241	139
2017-06	28171	2648	190912	84077	3929	153
2017-07	29925	2841	201788	90272	4225	133
2017-08	28149	2618	188408	86269	4041	161
2017-09	25810	2396	172533	79179	3856	145
2017-10	25742	2334	171885	79247	3829	128
2017-11	24526	2522	163824	74973	3804	133
2017-12	24005	2589	159492	74077	3757	139
2018-01	26169	2620	173514	81181	4181	197
2018-02	23972	2328	158089	75300	3836	179
2018-03	27888	2748	184594	86829	4544	171
2018-04	27680	2768	183313	86068	4455	198
2018-05	32204	3315	214236	99201	5093	199
2018-06	29251	3197	193743	90608	4756	213
2018-07	32033	3543	211558	99876	5171	187
2018-08	29009	3205	189281	92721	4700	185
2018-09	27451	3173	179811	86809	4549	172
2018-10	27671	3445	180984	87519	4572	198
2018-11	26528	3615	173020	84002	4474	171
2018-12	27309	3952	178795	85701	4473	168
2019-01	27832	3360	181617	88383	4755	206
2019-02	26993	3052	174536	87422	4754	171
2019-03	29888	3237	194026	96193	5248	183
2019-04	31260	3496	202944	100599	5393	172
2019-05	34132	4127	220565	110612	5845	174
2019-06	31879	3774	206012	103327	5470	214
2019-07	35002	4159	225666	114164	5796	241
2019-08	31668	3807	202263	105028	5376	210
2019-09	30451	3865	195024	100211	5211	207
2019-10	26972	3391	170736	90586	4808	200
2019-11	29588	3888	188519	98295	4972	212
2019-12	27782	3895	176231	92591	4924	182

as I have mentioned earlier I am kinda newbie so if there is any more improvement is required then guide me through.

thanks in advance

[v-yingjl]

Hi @sid24 ,

What do these categories mean and your expected output seems not clear.

Could you please share more details about this case for further discussion?

Sample file and expected output would help tremendously.
Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,

Yingjie Li

[parry2k]

@sid24 what you mean by data in order? What is your question or issue? Sorry seems like it is not very clear.