Forum Discussion

Sam7's avatar
Sam7
Icon for Advocate II rankAdvocate II
4 years ago
Solved

Power BI From and To Date Filtering with One Slicer

Based on this: https://www.youtube.com/watch?v=W5n8-5Q7mII How do I make this work, when I don't want the dates in the visual?  This works only if you have both dates in the visual.  I want to a...
Need Help
Sam7's avatar
Sam7
Icon for Advocate II rankAdvocate II
4 years ago

I have a whole page of visuals.  I want to have one slicer (single pick-date) and all the visual to change.  Based on the YouTube video - this is 99% of what I want, you can create a measure and add to filters, which only works on those visuals that have the date columns as outputs.  You cannot add the measure to visuals (or on whole page).  I do not want two date columns on my pie or funnel graphs. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Sam7,

    You can try to create a calculated table to expand the raw table date ranges based on two date fields and a category field.
    Then you can link two tables and use the new table date field as the source of the slicer to achieve one 'from ~ to' date slicer affects whole report pages.

    Solved: Spread revenue across period based on start and en... - Microsoft Power BI Community

    Regards,

    Xiaoxin Sheng