Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All!
In the below graph, I want to show 'Achieved Qty' as a percentage of 'Target'.
Eg:- For product D, I want to show 70% (i.e. 210/300) in the graph.
Is there any option to do this or is there any other custom visual to do this?
Thank you!
Solved! Go to Solution.
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':
I have the same requirement but struggling with it.
As shown in the below image created one measure to calculate the hours % based on BMI manhours against the BMcD manhours
Eg. BMI manhours in green 40135 and BMcD manhours in black 1025307, and want to display 3.91% on line chart.
Hi,
you can do this, if you are ok with showing the percentage values as a line. To do so select the visual type 'Line and Clustered Column Chart'
You will then get a chart like this with the percentages on a second Y-Axis:
Hi @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?
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:
Yes, that's possible. Replace it with whatever is your default delimiter (aka 'list separator'). This depends on your regional settings.
For me they look like this:
Thank you for your quick reply. Now it gave the same old answer 😞
Please see below:
That's because you added a 'column', not a 'measure'. Makes a difference - as you can see. Make sure to add 'measure':
User | Count |
---|---|
131 | |
108 | |
101 | |
67 | |
64 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |