Power BI Desktop Grouping Problem

[ellac]

Hi community!

I'm trying to wrap my head around a grouping problem in Power BI Desktop. I want to be able to group a categorical column in one group with one category and all the other categories in the other group, i.e. "Category 1" and "Other". This is working just fine. Here's my problem: is it possible to be able to choose this "Category 1" by some filter solution? I want to able to choose whatever category and then compare it to the rest of the categories.

Category 1 chosen in filter:

Category 2 chosen in filter:

Thanks in advance!

/Ella

[Mikelytics]

Hi ellac,

Please try this:

Measure 1 for your selected values (can be any formula):

#003_1 Base Measure (for selected Values) = 
SUM(FactInternetSales[SalesAmount])

Measure 2 foir the other values (refery to Measure 1) and in my case the ALL fucntion refers to the table where the categories are you want to filter by.

#003_2 MeasuresNonSelected (Others) = 
CALCULATE(
    [#003_1 Base Measure (for selected Values)],
    ALL(DimProductCategory)
)

-

[#003_1 Base Measure (for selected Values)]

when you put both measures in the pie chart

Can you try please?

Best regards

Michael

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your kudos.

[Mikelytics · Accepted solution]

also works with multi selection using the approach. 🙂

Best regards

Mikelytics

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your kudos.

[ellac]

Hi, thanks for your solution! This clearly solves the problem, even though I preferably wanted to use the grouping functionality in Power BI - but I will try to work with this (afraid that the solution will be slow since I have a lot of data to process in the measures). Thanks! 🙂

[Mikelytics]

Awesome! Thank you for your feedback! 😊

[Analystmate]

@ellac 
if you want to compare category data points using Slicer, Power Bi gives us the functionality to select multiple values in Slicer. if have to just off "Multi Select with Ctrl "from the Slicer setting.