Filtering between week end dates with two dropdown (start period and end period)

og_gremlins — Fri, 02 Feb 2024 14:04:54 GMT

Hello community,

I am facing the following problem. I want to be able to filter between two week end dates. I need to use two dropdown filter for a start and en period. Each drop down will only have the week end date (suppose every friday date). Currently PowerBI offers the possibility to filter between dates but with a slider ( which is a calnder with all dates displayed, not what I am lokking for). I found this post that tackle the issues : https://community.fabric.microsoft.com/t5/Desktop/Drop-down-box-to-filter-two-dates/m-p/1996708

However this solution does seems really efficient if I were to add a filter to each of my visualisations ?

Do you have any ideas how this could be done more efficiently ?

Let me know you thoughts or input about this 🤔

Re: Filtering between week end dates with two dropdown (start period and end period)

lbendlin — Sun, 04 Feb 2024 23:42:08 GMT

The hard way: Create two disconnected tables with your weeks, use these to feed the two slicers, and use measures for your visuals.

The easy way: Teach your users how to use the Filter Pane.

topic Filtering between week end dates with two dropdown (start period and end period) in DAX Commands and Tips

Filtering between week end dates with two dropdown (start period and end period)

Re: Filtering between week end dates with two dropdown (start period and end period)