Forum Discussion
For Sliced Filtered Date, Plot all the Event Data
- 1 year ago
I just tried this: https://community.fabric.microsoft.com/t5/Desktop/DATA-Slice-Interaction/m-p/3724209
And I was able to get the result I wanted but, curious, is there a way to do it without a visual level measure? Is this a hack or acceptabe solution? - Anonymous1 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 TeamIf 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
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
Thank you Gao for taking the time to explain it. Just when you think you are decent at PBI, there's always one more thing that stumps you.