Forum Discussion
From Excel to Power BI
Fantastic, this is what I am looking for, Thanks a million.. Power BI has lots of features, and I am learning all from the basic.
You are welcome. "Unpivot Other columns" changes thw wide dataset to a long one.
Please mark my original rely as Answer.
On the Format icon in the visualisation pane, there is an option to switch the orientation to horizontal.
Hi,
It is always recommended to create a Calendar Table.
say based on the R code, which its data is imported into Power BI, is it sufficient to do the plot without additional table for the Calendar?
res = read.csv2(
paste0(
"https://power.larc.nasa.gov/api/temporal/monthly/point",
"?parameters=T2M,T2MDEW,T2MWET,TS,T2M_MAX,T2M_MIN",
"&community=RE",
"&longitude=103.9690",
"&latitude=1.3665",
"&format=CSV",
"&start=2019",
"&end=2021"
),
skip = 14,
sep = ","
)
res$ANN <- NULL