Forum Discussion
Show performance vs last week
Hi
I am building a dashboard and have various metrics like the ones shown below. I'd like to add a little box near each gauge with the value of the previous week and then +/- type formatting. My model has a calendar built in so I can select for example "fiscal week" and this changes the charts. Ideally the +/- previous week would recognise the filter so the +/- would be dynamic but that is not essential. I have trend graphs below my gauges that my stakeholders could hover over but I'd also like to call out the values.
Is there a way to achieve this?
2 Replies
- amitchandakSuper User
PatrickWork2021 , check if tooltip page is supported on that.
https://docs.microsoft.com/en-us/power-bi/desktop-tooltips
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s - PatrickWork2021Frequent Visitor
thank you for this, I will look into it.