Forum Discussion

jj6291's avatar
jj6291
Frequent Visitor
4 years ago
Solved

Filter forcasted dates based on slicer selections

I hae a dataset where we have forecasts of the price of something based on every day of the year. i.e the forecasted 2022 price based on the 3rd of march, now based on the 4th of march etc. The data...
Need Help
  • jj6291's avatar
    jj6291
    4 years ago

    Hi, thanks for the suggestion. I ended up doing something similar. I made a new table and set columns up for overlapping periods and then made a 3rd table where I unpivoted the data manually. I think it was a bit overkill

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi jj6291,

It sounds like you want to achieve a custom filter effect based on slicer selections instead of filter effect.
If that is the case, I'd like to suggest you create an unconnected date table as the source of the slicer then you can write the measure expression and use it on your visual filter level to apply filter effects.

Applying a measure filter in Power BI - SQLBI

Deep dive into measure filters in Power BI Desktop - SQLBI

Regards,

Xiaoxin Sheng

jj6291's avatar
jj6291
Frequent Visitor
4 years ago

Hi, thanks for the suggestion. I ended up doing something similar. I made a new table and set columns up for overlapping periods and then made a 3rd table where I unpivoted the data manually. I think it was a bit overkill