Forum Discussion
Making a Simple Yield Curve Line Chart in Power BI
AllisonKennedyThanks for replying so soon, I appreciate it.
The "close" values are the price for each gov't bond at the end of each day, so every date will have a "close value" for each individual bond. I just want to be able to see the yield curve line for each single day, or the latest day, which I'm guessing means I need to add the date column to the x-axis (as you mentioned).
I just tried to add additional information as you said and it works as I need it to. The lack of additional data (date, symbol, etc.) was the problem. After adding "date" to the x-axis and filtering data for the latest single day, it works perfectly. Thank you very much for helping me solve this. Seems so simple in hindsight.
Community ChampionIn your screenshot 1, you have LOTS of Close values for each Ordinal Name, if you can better describe which value you want graphed in the line chart, we can help you translate that into DAX or Power BI, but you must have some sort of formula or aggregation or filter to determine which value to choose for the line graph.
Hope that makes sense?
AllisonKennedyThanks for replying so soon, I appreciate it.
The "close" values are the price for each gov't bond at the end of each day, so every date will have a "close value" for each individual bond. I just want to be able to see the yield curve line for each single day, or the latest day, which I'm guessing means I need to add the date column to the x-axis (as you mentioned).
I just tried to add additional information as you said and it works as I need it to. The lack of additional data (date, symbol, etc.) was the problem. After adding "date" to the x-axis and filtering data for the latest single day, it works perfectly. Thank you very much for helping me solve this. Seems so simple in hindsight.