Forum Discussion
Clustered column chart (percentage)
Hi Anonymous,
you need to define your 'Achieved%' as a measure using e.g.:
Achievement% = CALCULATE(SUM('Sales Table'[Achieved Qty]);'Sales Table'[SM Code])/CALCULATE(SUM('Sales Table'[Target]);'Sales Table'[SM Code])The measure needs to be formatted as '%'.
The resulting chart looks like this:
The visual settings:
That's because you added a 'column', not a 'measure'. Makes a difference - as you can see. Make sure to add 'measure':
Microsoft EmployeeHi Anonymous,
I don't think it is possible to do it currently. However, you can create a new measure to calculate the percentage of 'Target' and show it on the Tooltip. When hovering over a data point on the visualization, the percentage of 'Target' will be shown on the Tooltip like below.
Regards
Dear v-ljerr-msft and skasper,
Thank you for your valuable suggestions. But my actual situation is like this:
I want to visualize each Sales Manager's (ABC and XYZ) Achieved Qty, Target and Achieved Qty as a percentage of Target.
Eg: For the Sales Manager XYZ, Achieved% should be (150+100)/(200+150) = 71.4%
But in both 'Tooltip' method and 'Line and clustered column chart' method, it shows as 141.67% (i.e. 75%+66.67%).
Is there any suggestion to do this please?
- skasper
Responsive Resident
Hi Anonymous,
you need to define your 'Achieved%' as a measure using e.g.:
Achievement% = CALCULATE(SUM('Sales Table'[Achieved Qty]);'Sales Table'[SM Code])/CALCULATE(SUM('Sales Table'[Target]);'Sales Table'[SM Code])The measure needs to be formatted as '%'.
The resulting chart looks like this:
The visual settings:
Dear skasper,
Thank you for your reply. I tried your expression. But it gave an error. I think the expression doesn't identify the semicolon mark. Please see below: