The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I'm working on setting up a report page where users can select specific departments to compare against the rest. The idea is to use a slicer to pick certain departments, which would then be grouped into "Group 1," while all other departments automatically fall into "Group 2."
I tried setting this up, and I’ve attached a picture showing my current setup. Unfortunately, it doesn’t work as intended. Specifically, I’m struggling with how to make the non selected departments go into Group 2.
Solved! Go to Solution.
@eaj you can use a measure to return the values instead of 1 or 0 and get the totals
I have created two tables
Thanks, this might be my lack of experience talking, but if it is a measure, how do I get lets say total revenue for group 1 and 2. I can't filter on measures, right?
Doesn't it have to be some calculated column in my main department table?
@eaj you can use a measure to return the values instead of 1 or 0 and get the totals
That is very clever, didn't think of that. Thanks!