How to Toggle Between Time Periods (Day, Week, Month, Quarter, Year) in Power BI Without Using Drill

batman — Thu, 17 Oct 2024 12:53:33 GMT

I need help with filtering by Day, Week, Month, Quarter, and Year.

I created a field parameter called "Period" and attempted to build a line chart using Year and this parameter. However, when users select a date range longer than a year, I don't want the weeks to overlap. Currently, every time I switch between Month and Quarter, I have to use the drill down feature on the chart. Is there a way to achieve this without having to drill down, or is there a simpler solution?

Re: How to Toggle Between Time Periods (Day, Week, Month, Quarter, Year) in Power BI Without Using Drill

dharmendars007 — Thu, 17 Oct 2024 15:25:50 GMT

Hello batman ,

I assume you already have date table, based on that you can create the below measure that dynamically switches between the periods depending on the selected field parameter

Selected Period Value =
SWITCH(TRUE(),
SELECTEDVALUE('Period'[Period]) = "Day", MAX('Date'[Date]),
SELECTEDVALUE('Period'[Period]) = "Week", MAX('Date'[Week]),
SELECTEDVALUE('Period'[Period]) = "Month", MAX('Date'[Month]),
SELECTEDVALUE('Period'[Period]) = "Quarter", MAX('Date'[Quarter]),
SELECTEDVALUE('Period'[Period]) = "Year", MAX('Date'[Year]))

1.Add the Period slicer to your report page using the field parameter you created.

2.In the Line Chart, use the dynamic period value measure as the axis.

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes 👍 are much appreciated!

Thank You

Dharmendar S

topic Re: How to Toggle Between Time Periods (Day, Week, Month, Quarter, Year) in Power BI Without Using Drill in DAX Commands and Tips

How to Toggle Between Time Periods (Day, Week, Month, Quarter, Year) in Power BI Without Using Drill

Re: How to Toggle Between Time Periods (Day, Week, Month, Quarter, Year) in Power BI Without Using Drill