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 they want ( no prefiltering), slicers cointains same list of countries, from separate dedicated DT. I've tried to group them in one table report to ease the "at first glance" analysis. 

 

MY PROBLEM : the countries are going to the wrong group, they're inverted. How can I make it work ?

 

Thank you in advance for your help.

 

Rest of the report works correctly, new incremental change is about the Grouping for Table view.

 

JB

 

PS: details below

 

view of the report:

Table's elements:

 

For grouping my countries I've done: (problem the countries are going to the wrong group)

_Comparison_Measures_Countries =
DATATABLE(
    "Group", STRING,
    {
        {"A"},
        {"B"}
    }
)

 

Details for slicers A: 

Selected_Country_A = VALUES(_CountrySelectionA[country])
List of Countries in Custom TABLE 

 

Details for slicers B: 

Selected_Country_B = VALUES(_CountrySelectionB[country])

List of Countries in Custom TABLE 

 

 

Need Help

2 Replies

  • 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