Forum Discussion

weakneee's avatar
weakneee
Frequent Visitor
3 years ago
Solved

PORTION OF A WHOLE | PIE CHART

Hi, 

I hope you're doing well.

 

I believe that I have a quite simple doubt about representation in a pie chart. 

 

I want to represent a portion of a whole in the chart, but, instead of display the difference, it is presenting the summing of the values. 

 

I have 302 "MATRICULA" and 226 of them did "TREINAMENTO 1". In the chart is presented the summing of these values, treating as they're different, but the latter is inside of that. How can I treat the values as one, without summing? 

 

 

 

  • andrewpirie's avatar
    andrewpirie
    3 years ago

    I agree with eliasayy's solution, below are some additional details but it's the same solution they've given.

     

    Assuming you have a 1:M relationship from Matriculas to Treinamentos, one solution is to add measures to calculate both portions of the visual: 

     

    QTD. TREINAMENTO 1 = 
    CALCULATE(
        COUNTROWS(
            FILTER(
                RELATEDTABLE('Treinamentos de Janiero'),
                'Treinamentos de Janiero'[Treinamento - Nome] = "CNV"
        )
    )
)
    MATRICULAS = COUNTROWS(Matriculas)
    MATRICULAS WITH NO TREINAMENTO 1 = [MATRICULAS] - [QTD. TREINAMENTO 1]

     

    Add both [QTD. TREINAMENTO 1] and [MATRICULAS WITH NO TREINAMENTO 1] to the visual's Values fields

     

     


    Note that you will not be able to filter other visuals by selecting the two categories on this visual - if that's required, you'll need a more complex solution.

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    hello weakneee , i think what youre asking for is if we can just put the "TREINAMENTO 1" measure related to "MATRICULA" as the max value and not sum it up, i honestly think its impossible BUT a workaround could be give,

     

    lets say 
    count all = MATRICULA
    count of = TREINAMENTO 1
    and extra = count all - count of

    now just change the color of "extra" to match your background and put the data label inside and choose color same as background too and just change label name of "extra" to space so it doesnt show in legend.
    i hope this helps

     

    • weakneee's avatar
      weakneee
      Frequent Visitor
      3 years ago

      Hi, Anonymous . 

       

      I hope your doing fine! 

       

      I want to thank you as well for taking your time to help me! 

  • andrewpirie's avatar
    andrewpirie
    Icon for Resolver II rankResolver II
    3 years ago

    I agree with eliasayy's solution, below are some additional details but it's the same solution they've given.

     

    Assuming you have a 1:M relationship from Matriculas to Treinamentos, one solution is to add measures to calculate both portions of the visual: 

     

    QTD. TREINAMENTO 1 = 
    CALCULATE(
        COUNTROWS(
            FILTER(
                RELATEDTABLE('Treinamentos de Janiero'),
                'Treinamentos de Janiero'[Treinamento - Nome] = "CNV"
        )
    )
)
    MATRICULAS = COUNTROWS(Matriculas)
    MATRICULAS WITH NO TREINAMENTO 1 = [MATRICULAS] - [QTD. TREINAMENTO 1]

     

    Add both [QTD. TREINAMENTO 1] and [MATRICULAS WITH NO TREINAMENTO 1] to the visual's Values fields

     

     


    Note that you will not be able to filter other visuals by selecting the two categories on this visual - if that's required, you'll need a more complex solution.

    • weakneee's avatar
      weakneee
      Frequent Visitor
      3 years ago

      Hi, andrewpirie, 
      Thank you so much! This is what I what wanted.
      The other visuals I can work separately. 

       

      Once again, thank you for taking your time to help me.