cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PowerBIOrg
Frequent Visitor

Slicer to compare One vs All

Hi All, 

 

I have a report to compare the data between ONE(1) Head/Department and ALL Head/Department.

I have 2 tables: UserTable and RawTable (both are not linking any relationship yet).

I want to have a Slicer that will show like the Yellow highlighted Box when it meet different Scenarios. 

Screenshot 2021-06-14 104650.png

For example (Scenario 1),

  • When we applied Report-Level Filter for UserTable 'Head' column = A, the slicer will show 2 options: 'A' and 'All'. 
  • When I choose option 'A' in the slicer, it will check on data related to Head 'A' only.
  • When I choose option 'All' in the slicer, it will check on all data including Head 'A' data.

For example (Scenario 2),

  • When we applied Report-Level Filter for UserTable 'Department' column = B1, the slicer will show 2 options: 'B1' and 'All'. 
  • When I choose option 'B1' in the slicer, it will check on data related to Department 'B1' only.
  • When I choose option 'All' in the slicer, it will check on all data including Department 'B1' data.

For example (Scenario 3),

  • When we didn't applied any to Report-Level Filter, the slicer will show only 1 options: 'All'. 
  • When I choose option 'All' in the slicer, it will check on all data.

 

 

 

Thanks in advance!

1 REPLY 1
daxer
Solution Sage
Solution Sage

@PowerBIOrg 

 

Despite lots of text and nice pictures... I'm exactly as wise as I was before seeing this post. I'd kindly suggest reading this

 

https://community.powerbi.com/t5/DAX-Commands-and-Tips/How-to-Get-Your-Question-Answered-Quickly/td-...

 

.... and then rephrasing your problem.

 

To get good answers (or at all) it's good to see the problem you have through the eyes of those who have never seen it before in the first place and then think about how to phrase it. Just think that you're explaining this to people who have no idea whatsoever what you've been doing.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.