Showing dates as legend of the graph

[Dunner2020]

Hi there,

I have a report that contains a fact table and two dimension tables (i.e. date and time). I am plotting three line graphs (for today, yesterday, and day before yesterday) that shows average temperature during 24 hours. Example is shown below:

I calculated three measures to calculate the average temperature. For example: today temperature measure looks as follow:

Today = CALCULATE(AVERAGE(Fact[TEMPERATURE]),Dates[Date]= TODAY())

Now I want to change the legend of the chart with the actual dates. For instance, instead of today, it should show the date (i.e. 13/7/2022). I am not sure how to bring in the date as a legend. Any help would be really appreciated. Thanks

[amitchandak]

@Dunner2020 , Based on what I got. You need a column like this and use that as a legend

Date Type = SWITCH(TRUE(),'Date'[Date]=TODAY(),"Today"
,'Date'[Date]=TODAY()-1,"Yesterday"
,'Date'[Date]=TODAY()-2,"Day before Yesterday"
,'Date'[Date]&"")

[Dunner2020]

@amitchandak , I want to show dates as legend not the text. Instead of showing Today, I want to show today's date

[amitchandak]

@Dunner2020 , the Last three days of data

Check if this measure can help

oday = CALCULATE(AVERAGE(Fact[TEMPERATURE]),filter(Dates, Dates[Date]>= TODAY()-2 && Dates[Date]<= TODAY()) )