Forum Discussion

t0meky's avatar
t0meky
Frequent Visitor
6 years ago

Grouping in ribbon chart

Hi All,
I am new with Power BI and I am trying to show the ranking between the items per country between the periods.

For now I have three of them: 1,2 and 3.

I would like to show the delta between two groups: 1+2 and 1+2+3 so only the ranking of changes between 1+2 (aggregated) and 3 (aggregated with the rest).

 

I am able to group 1+2 into one group and 3 is ungroupped, but I would like to have it added to 1+2, so I will see the overall change. Current change is not representative. Weeks 1,2 and 3 are placed in CW table and are not divided. 

 

Current situation:

 

 

 

I need the group 1+2+3 on place of the 3 from above image. Then I will be able to present the ranking between the delta of those two groups. Second group should look like:

 

 

 

Thank You in advance for your support!

 

Regards,
Tomasz

 

Need Help

5 Replies

  • v-xuding-msft's avatar
    v-xuding-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi t0meky ,

    Please follow the steps and check if it is what you want.

    • Create a new table manually

    • Create measures like below
    Measure =
VAR ab =
    CALCULATE (
        SUM ( 'Table'[ Sales] ),
        FILTER ( 'Table', 'Table'[Country] = "Canada" || 'Table'[Country] = "France" )
    )
VAR abc =
    CALCULATE (
        SUM ( 'Table'[ Sales] ),
        FILTER (
            'Table',
            'Table'[Country] = "Canada"
                || 'Table'[Country] = "France"
                || 'Table'[Country] = "Germany"
        )
    )
RETURN
    IF ( MAX ( 'Table 1'[Column1] ) = "1 & 2", ab, abc )

     Please see the attachment below.

     

    Best Regards,

    Xue Ding

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

    • t0meky's avatar
      t0meky
      Frequent Visitor
      6 years ago

      Hi v-xuding-msft ,

      I have a problem, as this measure is not valid for me. 

      In my case Sales should be represented by different values of company - it will be cumulated for 1&2 as well as 1&2&3.

      Column comp (represented in your case as sales) is not a count, but the names.

       

      Column Country (in your case country names) in my case is named as 1 , 2 , 3.

       

      Could you tell me what can be wrong with that?

      My measure is not done, so I am not able to visualize the data.

      Thank You in advance.

       

      Regards,
      Tomasz

      • v-xuding-msft's avatar
        v-xuding-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi t0meky , 

        You could change the SUM( sales) to MAX (name) and change the country name to 1,2,3. Please reference the formula below to modify yours.

        Measure =
VAR ab =
    CALCULATE (
        MAX( 'Table'[ Name] ),
        FILTER ( 'Table', 'Table'[Country] = "1" || 'Table'[Country] = "2" )
    )
VAR abc =
    CALCULATE (
        MAX( 'Table'[ Name] ),
        FILTER (
            'Table',
            'Table'[Country] = "1"
                || 'Table'[Country] = "2"
                || 'Table'[Country] = "3"
        )
    )
RETURN
    IF ( MAX ( 'Table 1'[Column1] ) = "1 & 2", ab, abc )

        If it still doesn't work, please share some sample data and your expected result. Then we will understand clearly.

         

        Best Regards,

        Xue Ding

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