Forum Discussion

jitpbi's avatar
jitpbi
Icon for Post Patron rankPost Patron
5 years ago
Solved

values for next 5 days

Hi,

 

I am working on a report where 5 days (Today+next 4 days) weather data is visualzing on card visuals. the below is the sample data:

 
datesHumidityTemperatureWindspeedExpectationImage
2/11/202117.7524.10753.41overcast cloudshttp://openweathermap.org/img/w/04n.png
2/12/20211824.118753.8525overcast cloudshttp://openweathermap.org/img/w/04d.png
2/13/20211923.961253.15875clear skyhttp://openweathermap.org/img/w/01d.png
2/14/202117.62524.651252.71625clear skyhttp://openweathermap.org/img/w/01d.png
2/15/202117.37524.816252.4925scattered cloudshttp://openweathermap.org/img/w/04d.png

 

I have to present Humidity, Temperature, Windspeed & Image on card visual for each date (today to today+4 days) seperately.

For the numeric data (Humidity, Temperature & Windspeed) using the below measures which are working fine.

 

Temp_Today = CALCULATE(SUM(Weather2[Temperature]),FILTER(Weather2,Weather2[dates] = today()))
Temp_Today+1 = CALCULATE(SUM(Weather2[Temperature]),FILTER(Weather2,Weather2[dates] = today()+1))
Temp_Today+2 = CALCULATE(SUM(Weather2[Temperature]),FILTER(Weather2,Weather2[dates] = today()+2))
Temp_Today+3 = CALCULATE(SUM(Weather2[Temperature]),FILTER(Weather2,Weather2[dates] = today()+3))
Temp_Today+4 = CALCULATE(SUM(Weather2[Temperature]),FILTER(Weather2,Weather2[dates] = today()+4))
 

Now, I have 2 issues:

1. How to write dax to represent text/image data for 5 seperate days (today to today+4 days)

2. Is there any other efficient way to show data for next 5 days, as 5 no. of measures are required for each parameters. So, we can write the dax in more efficient way to keep least no. of measures.

 

Thanks

 

 

 

 

 

Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi jitpbi ,

     

    I'm afraid that you can't show image in card visual. I suggest you just use table visual and add visual level filter on it to show date from today to today+4:

     

     

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

     

    Best Regards,

    Dedmon Dai

3 Replies

    • jitpbi's avatar
      jitpbi
      Icon for Post Patron rankPost Patron
      5 years ago

      Thank you amitchandak  for the suggestions.

      Relative date slicer doesn't fit as it takes date range while i required on that particular day :

       

      Also please suggest how to write dax for text fields: "Expectation" & "Image"

       

      Thanks

       

       

       

       

       

       

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi jitpbi ,

     

    I'm afraid that you can't show image in card visual. I suggest you just use table visual and add visual level filter on it to show date from today to today+4:

     

     

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

     

    Best Regards,

    Dedmon Dai