How to make a solar analemma chart in Power BI?

[Regiso]

The NOAA.gove website offers a solar calculation data set that includes this analemma created in excel:

I am using the same excel file to create a similar  chart in power bi, but, power bi but I'm not sure what levers I need to pull to simplify the line structure. Please give me your ideas! Thanks.

Here is the link to the original data:

NOAA.gov solar calculations excel file 

[ThxAlot · Accepted solution]

It's nothing but simply a scatter plot.

[PhilipTreacy]

Hi @Regiso 

What data in that file would you use to create the plot?  That analemma chart isn't in the NOAA file.

According to this you need Azimuth vs Altitude

AnalemmaPlot | Wolfram Function Repository

Regards

Phil

[Regiso]

My apologies I sent the incorrect link - this is the correct file

https://gml.noaa.gov/grad/solcalc/NOAA_Solar_Calculations_year.xls 

[pallavi_r]

Hi @Regiso ,

It is not available with default charts and visuals of Power BI. With dax also it would be complicated. You may try out by creating Power BI visuals with Python library. 

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-python-visuals

Matplotlib is the recommended library for the same and search for github resources which has solar analemma chart implemented, and try this in Power BI.

Thanks,

Pallavi

[Regiso]

@pallavi_r thanks for your reply. I am stunned that excel can generate the chart so easily but power bi can't match that!

[ThxAlot · Accepted solution]

It's nothing but simply a scatter plot.

[pallavi_r]

Superb @ThxAlot .. interesting and great catch 

[Regiso · Accepted solution]

🍎 @ThxAlot  you are indeed the super user!  Thanks.A.Lot!!