Forum Discussion

ColinRE's avatar
ColinRE
Icon for Helper I rankHelper I
1 year ago
Solved

For Sliced Filtered Date, Plot all the Event Data

Hey Folks,   Been struggling with this seemingly simple problem: for a sliced Date Time, get the event and plot all the associated values.    Click here for PBI File   What I want:     ...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi ColinRE ,

     

    As you discovered, you need to create a separate unconnected table for the date slicer to ensure that the 'model'[date] column filter does not affect the Model table. 


    Editing interactions, using mediators like ALL, REMOVEFILTERS, etc. in the same table cannot do this.

    'Model'[event_id] actually contains filters derived from 'Model'[Date] as well, and they interact with each other (from same table), you can't keep filters from just one of them.

    Best Regards,
    Gao

    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum