Forum Discussion

JBal86's avatar
JBal86
Frequent Visitor
1 year ago

Custom Grouping on visual gone wrong (inverted), please help

Hello,    For my Users, I have created a report that compare two different group of Country (selected in slicers).   As you can see below, user needs to select in slicer A and B, Countries as the...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi JBal86 ,

 

I think there should be a fact data table in your data model. I suggest you to add [Group] column in this table and the create data hierarchy in matrix.

Get the first word from [Country] column by LEFT() function.

Group =
LEFT ( 'TableName'[Country], 1 )

 

Best Regards,
Rico Zhou

 

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

 

JBal86's avatar
JBal86
Frequent Visitor
1 year ago

Hi Anonymous,

 

Thank you for your answer.

I'm not sure I quite understand your solution. Can you extrapolate some more please. 

Also, I think I need to add some extra U(x) details on the report because I'm not sure if your fix would work correctly.

 

Slicer A and B have the same list of countries comming form main DT holding the data:

_CountrySelectionA = DISTINCT('Sales company')
_CountrySelectionB = DISTINCT('Sales company')
 
For both I have a measure to get the selected ones, that I propagate futher with calculation.
Selected_Country_A = VALUES(_CountrySelectionA[country])
Selected_Country_B = VALUES(_CountrySelectionB[country])
 

It means that the selection can be more random than mine. In my example above, I used an unfortunate combination to ease me the dev work. (Countries begin with the same letter). The user can use more advance grouping, for example:

I'm trying to find a way to group seperatly each selection made in slicer A and B.

 

The Goal is to add an additional layer to this report, to group the selection and compare each grouping results.

 

Thank you once again for your answer 🙂

 

JB