Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Total Label Value into variable - Stacked bar chart

In a stacked bar chart, i want to show percentage of each stack in a bar. I have tried using below. This worked well for many other reports. In a particular report, i get only 100%. I have tried all ...
Need Help
Tips and Tricks
  • v-kelly-msft's avatar
    v-kelly-msft
    5 years ago

    Hi Anonymous ,

     

    Can you share your .pbix file for test?

    Remember to remove the confidential information.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

  • v-kelly-msft's avatar
    v-kelly-msft
    4 years ago

    Hi Anonymous ,

     

    Try:

    % Amended =
DIVIDE (
    CALCULATE (
        COUNT ( Total_Amended[RegistrationNumber] ),
        FILTER (
            ALLSELECTED ( Total_Amended ),
            Total_Amended[New_Status] = MAX ( Total_Amended[New_Status] )
                && Total_Amended[RegionName] = MAX ( Total_Amended[RegionName] )
        )
    ),
    CALCULATE (
        COUNT ( Total_Amended[RegistrationNumber] ),
        FILTER ( ALLSELECTED ( Total_Amended ), [RegionName] = MAX ( [RegionName] ) )
    )
)

    I made a simple sample for reference,you will see below in my example:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my areply as a solution!

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I was getting 100% always because the given denominator used for calculating percentage are coming from different table using relationship. once that is corrected, the values were coming as expected.