Weather Visual
Hello all! Hope you are all well and somebody out there can help me. I am currrently building a dashboard and would like to have the weather temprature showing on the "card" visual. any ideas how to make this work? I have had a look online and cant seem to come across anything. If you have a idea or any tips please let me know. Many thanks 🙂
DAX Calculations for representation of percentage change from the previous day
Hello experts! I am still learning Power Bi and a beginner. I am trying to track daily performance of all the stores. Please help me in finding the percentage change from the max date to a day before max date for each store. Here the "Daily Input" is constant, rarely changes and "Outputs" values varies daily with new dates updated. A sample raw data with calculations and expected outputs are available in the link https://docs.google.com/spreadsheets/d/1Fi5d1TV3sV-4QZzjEggFDChg7n11cgaciVknF76GYwk/edit#gid=709207873 Output: Formulae used: Thank you for your support and efforts in advance!!
Adding 2 custom lines to line and stacked column chart
I currently have a pareto chart by number of cases per event date. I'm trying to add a rolling 7 day average calculation to this but I keep getting: Where I was hoping to have something like this? I'm currently running my 7 day rolling average by [Event Date]: 7 Day Rolling Average - Notification Date = CALCULATE(SUM('Sheet1'[Epi Date Count]),DATESINPERIOD('Sheet1'[Event Date],LASTDATE('Sheet1'[Event Date]),7,DAY)) / CALCULATE(DISTINCTCOUNT('Sheet1'[Event Date]),DATESINPERIOD('Sheet1'[Event Date],LASTDATE('Sheet1'[Event Date]),7,DAY)) Is there any way this can be done? Thanks in advance Please find file attached https://www.dropbox.com/s/c3hfci8jabydxv1/Pareto.pbix?dl=0
