Forum Discussion
Help Needed: Removing Filter from Slicer
Hi everyone,
Trying to mimic plannedStart to Planned Finish, client wants no filter.
I'm currently working on a Power BI project and need some assistance with removing a filter from a dataset.
Table: Projects
Format: Short Date/Time (3/14/2001 format)
Right Click: Format as Anchor Date
Slicer Settings: Relative Date
Here's what I've tried so far:
Select the "Planned Start" Slicer:
- Clicked on the slicer for "Planned Start" to select it.
Open the Filters Pane:
- Ensured that I was in the "Filters" pane on the right side of the screen.
Verify Filter Settings:
- Checked that the "Planned Start" filter is set to "is (All)" as mentioned.
Adjust the Visual Properties:
- Went to the "Format" pane on the right.
- Adjusted the settings under "Visual" to match those of the "Planned Finish" slicer
- . Tried syncing filter, not sure if I did this correctly as other report is hidden but has the filter removed.
Despite following these steps, I'm still encountering issues with the filter. Has anyone experienced a similar issue or can provide guidance on what I might be missing?
Any help would be greatly appreciated!
Thanks in advance!
Hello,
Have you tried the "Edit Interactions" option? If you click your slicer, then Format, then "Edit interactions", you can decide which visuals your slicer interacts with.
If it is DAX related, you can consider using the ALL() or REMOVEFILTER() functions
7 Replies
ExcelMonkeImpactful Individual
Hello,
Have you tried the "Edit Interactions" option? If you click your slicer, then Format, then "Edit interactions", you can decide which visuals your slicer interacts with.
If it is DAX related, you can consider using the ALL() or REMOVEFILTER() functionsWhere in the data set could I apply the DAX? Could you give me an example of the syntax with the data I've shown ? Thanks ExcelMonke
Hi yoshi556 ,
I think ExcelMonke solution is commendable. Did ExcelMonke answer solve your problem?
If it is, kindly Accept it as the solution. More people will benefit from it. Or if you are still confused about it, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Good morning,
Thanks for the insight, tried a number of interactions.
Still no result, I need to mimic the other filter" no filters applied".
Is this something I can rectify at the data model/layer?
I am new to Power BI and coukld use some guidance on the DAX syntax and as to where I can place the code.
Thanks,
Regards,
YOSHI
Anonymous
Hi yoshi556 ,
Based on your description, you want to create Planned Start slicers and Planned Finish slicers, but they don't affect each other, right?
You can click Edit Interaction as shown in the image below.
Then the result is as follows.
If I misunderstand what you mean, please clarify in a follow-up reply.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Not quite, I simply want the slicer to have no filter. Is this modified at the data layer? If you see the PlannedFinish, it has no filter applied. I tried to copy the same attributes and setting to my PlannedStart but no results. Thanks Anonymous
Anonymous ExcelMonke , I solved the slicer, i changed it to relative time option. Thanks to the two of you for the outstaning help, def. pushed me further into my Power BI journey. Yoshi
