Power Query : Show Report Using Slicer Based on Date As Header

[muhammad susanto]

hi all..

i have data like this

testing date as header.xlsx
	A	B	C	D	E	F
1	data sources (original)
2	Region	Raw data 2022	per jan 2022	per feb 2022	per mar 2022
3	Jakarta	10.000	100	200	25
4	Hongkong	5.000	200	250	86
5	Hawai	25.000	120	20	84
6	Tokyo	21.000	212	25	95
7	Hamburg	34.000	222	20	21
8	Serawak	10.000	100	45	24
9	London	24.000	34	76	50
10
11	after using Power BI/Report -- dynamic show data based on month of period
12	Region	Raw data 2022	per jan 2022
13	Jakarta	10.000	100
14	Hongkong	5.000	200
15	Hawai	25.000	120
16	Tokyo	21.000	212
17	Hamburg	34.000	222
18	Serawak	10.000	100
19	London	24.000	34
Sheet1

i want show data as report based on date in header with dynamic date (month) using slicer
e.g. show data only feb 2022 .etc...using slicer
anyone help, greatly appreciated

susant

 

[muhammad susanto]

maybe this make more clear:
my condition,
1. in my data not contains date
2. date only on the top as header like per jan 2022, per feb 2022, per mar 2022,....etc.
how to use slicer (date as controller) while my date not contains date (date in rows)?
using slicer, i want to show report e.g. showing report/dashboard per jan 2022 or report per feb 2022, etc..
my main problem, my data not contains date .
how to fix this problem?