Yield curve in PowerBI

[AndreeaV]

Hi,

I would like to create a Treasury yield curve in PowerBI like the one on the left in this app I found online. https://app.powerbi.com/view?r=eyJrIjoiZDc1ZGFhYzItZWIyYy00N2UyLTg0YzgtMGViYWEyYzZhMDQ3IiwidCI6IjRhY...

Data looks like this: https://home.treasury.gov/resource-center/data-chart-center/interest-rates/TextView?type=daily_treas...

I would like to know how to make the curve for one day, so I do the same for the rest. I tried to create measures, but I got error messages saying that I couldn't display more than one value in a measure. If I create a table for each date I want, I can't create the chart. Plus, creating tables is not dynamic.

Thanks!

[AndreeaV]

Thanks @Anonymous !

[Anonymous · Accepted solution]

Hi @AndreeaV ,

If you want to create line charts as the app in the link, I think you need to transform your underlying data by UNPIVOT function.

Select [Date] column and use UNPIVOT other columns. New table should look like as below.

Measure:

Most Recent = 
VAR _Recent_Date = CALCULATE(MAX('Table'[Date]),ALL('Table'))
RETURN
CALCULATE(SUM('Table'[Value]),'Table'[Date] = _Recent_Date)

Week Ago = 
VAR _Recent_Date = CALCULATE(MAX('Table'[Date]),ALL('Table'))
return
CALCULATE(SUM('Table'[Value]),'Table'[Date] = _Recent_Date - 7)

Month Ago = 
VAR _Recent_Date = CALCULATE(MAX('Table'[Date]),ALL('Table'))
return
CALCULATE(SUM('Table'[Value]),'Table'[Date] = _Recent_Date - DAY(EOMONTH(_Recent_Date,-1)))

...

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.