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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

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

Top Solution Authors