• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Exclude a part of Chart from being filtered in power BI

Tim A

New Member
Hi
I have a chart that has a Plan and Full Year Plan numbers on the same chart (radial actually). I also have a slicer that Selects Months. I wonder if I can have FY Plan not be affected by Selection of Months, but Plan numbers will change. For example FY plan is $100, if Month#6 is selected I want Plan number to show plan for June and FY plan still show $100
Thank you
 
Interesting... without messing with actual DAX, here is a simple way to do it.
Make two charts, size them same way and overlay one on top of another. Now link the slicer to interact with only the top chart. That should do the trick.

If you want to venture in to DAX, you can use ALL() to clear filters from a table. So I would simply ALL(calendar[months]) to handle this.

All the best.
 
Back
Top