Forum Discussion

NavaneethaRaju's avatar
4 years ago
Solved

Need a measure

Hi,  I enclosed the image. bar chart i want to display the percentage values like the same in matrix visual. in matrix i enable percent of column total. but in barchart we dont have any option. ...
  • v-yanjiang-msft's avatar
    4 years ago

    Hi NavaneethaRaju ,

    According to your description, I create a sample, here's my solution.

    Create a measure.

    Measure% =
    VAR _Total =
        SUMX (
            FILTER ( ALL ( 'Table' ), 'Table'[Month] = MAX ( 'Table'[Month] ) ),
            'Table'[Measure]
        )
    RETURN
        DIVIDE ( [Measure], _Total )
    

    Put this measure in the column chart visual, get the correct result.

    I attach my sample below for reference.

     

    Best Regards,
    Community Support Team _ kalyj

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