Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
89 | |
84 | |
76 | |
64 |
User | Count |
---|---|
135 | |
111 | |
98 | |
98 | |
92 |