October 27, 2024
Chicago 12, Melborne City, USA
SQL

How to show previous weeks on power bi


hope you are having an amazing day

I’m currently working on a power bi report, I’ll give you a few context about it

I have a dataset where I have every downtime record for a company with the total of downtime in minutes for each record, also I have the datetime and the fiscal week

So I need to add a single select slicer where I can choose the week that I want to filter and in a bar chart display the downtime sum for the week selected and the downtime for the past 4 weeks (one bar for each week)

I’ve been trying and I haven’t found a solution so I hope some of you could help me please.

Regards!



You need to sign in to view this answers

Leave feedback about this

  • Quality
  • Price
  • Service

PROS

+
Add Field

CONS

+
Add Field
Choose Image
Choose Video