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
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Urdu Hindi D365 Bootcamp 768x460.png

Urdu Hindi D365 Bootcamp

Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.

Top Solution Authors