Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
eaj
Helper I
Helper I

Creating a Report Page with Department Comparison Using a Slider

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.

 

 

eaj_0-1724313407089.png

 

1 ACCEPTED SOLUTION

@eaj you can use a measure to return the values instead of 1 or 0 and get the totals

 

View solution in original post

4 REPLIES 4
raji_n
Resolver I
Resolver I

I have created two tables

raji_n_0-1724319148989.png

Measure1 = IF(ISFILTERED('Table (2)'[Column1]),IF(MAX('Table'[Column1]) in ALLSELECTED('Table (2)'[Column1]),1,0))
Measure =
IF([Measure1]=1,"GR1","GR2")
raji_n_1-1724319185401.png

 

 

This is my outcome where whichever value is selected is shown as GR1, others GR2

@eaj 

 

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! 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.