Help Needed: Removing Filter from Slicer

[yoshi556]

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:

1. Select the "Planned Start" Slicer:

   • Clicked on the slicer for "Planned Start" to select it.

2. Open the Filters Pane:

   • Ensured that I was in the "Filters" pane on the right side of the screen.

3. Verify Filter Settings:

   • Checked that the "Planned Start" filter is set to "is (All)" as mentioned.

4. 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
5. . 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!

 

[yoshi556]

@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

[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. 

[yoshi556]

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 

[yoshi556]

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

@ExcelMonke 

@Anonymous 

[Anonymous]

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. 

[ExcelMonke · Accepted solution]

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

[yoshi556]

Where 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