Question

[lmerritt]

PBI Community

I am using this You Tube Video https://www.youtube.com/watch?v=POCCTdiWjls  to put in the line stacked bar chart

When i place the 3 calculated columns (Target, Unmet Bar, Met Bar)  into the column y- axis PBI puts in a count on it.

i want the actual percentage to be displayed.

Note: I can't do the formulas in a measure like this video because the calculations are not the same. I don’t have Sales Data.

Here are the calculations:

Target is the value in the table, like .85,1 , etc

UnmetBar =

IF('Vertical Table'[Target]  > 'Vertical Table'[Actual],

'Vertical Table'[Actual] - 'Vertical Table'[Target]

 )

MetBar =

IF('Vertical Table'[Actual]  > 'Vertical Table'[Target],

'Vertical Table'[Actual] - 'Vertical Table'[Target]

 )

When I move the Target, Met Bar and Unmet Bar fields to the column y-axis , it wants to perform a count, sum, min, max. There is no option to leave out performing any calculation.  I just want the value to be shown on the chart.
If there actual is larger than the target, display that in red and if the target is > then the actual then display it in blue. I don’t need the gray bar to display the sales.
The video shows a Total Target and displays that on the Line y-axis.  Do I just leave that off of my PBI?

I have the 3 columns above, Target, Met Bar and Unmet Bar as follows:

1. Summarization = Don't Summarize
2. Data Category = Uncategorized
3. Format = General
4. Data Type = Decimal Number

How do I solve this issue.  I see posts like mine but don’t see an actual response when they ask the PBI community. 

I have the Target and Actual as a decimal number in the table.

Year	Month	Target	Actual	KR#	UnmetBar	MetBar
2023	January	0.95	0.857	1.1 BAU	-0.093
2023	February	0.95	1	1.1 BAU		0.05
2023	January	1	0.285	1.3 BAU	-0.715
2023	February	1	0.857	1.3 BAU	-0.143
2023	January	0.8	0.4285	2.1 BAU	-0.3715
2023	February	0.8	0.4285	2.1 BAU	-0.3715
2023	January	0.97	1	3.1 BAU		0.03
2023	February	0.97	1	3.1 BAU		0.03
2023	January	1	1	3.2 BAU
2023	February	1	1	3.2 BAU
2023	January	0.5	0	4.1 BAU	-0.5
2023	February	0.5	1	4.1 BAU		0.5
2023	January	0.7	0.18	4.2 BAU	-0.52
2023	February	0.7	0.52	4.2 BAU	-0.18
2023	January	0.95	0.41	5.1 BAU	-0.54
2023	February	0.95	0.99	5.1 BAU		0.04
2023	January	0.65	0.41	5.2 BAU	-0.24
2023	February	0.65	0.89	5.2 BAU		0.24
2023	January	0.9	1	5.3 BAU		0.1
2023	Feburary	0.9	1	5.3 BAU		0.1

Here is the Visual. It stops at KR#3.1 and I don’t know why. Will it be corrected when PBI is no longer doing a count?

Please let me know if you need anything else.

[lbendlin]

Sounds like you were going for calculated columns rather than measures?

[lmerritt]

I figured out my issue so no need to address my question.

[lmerritt]

Correct.  As I mention in my post, I can't do the formulas in a measure like this video because the calculations are not the same. I don’t have Sales Data.

It errors out if I do a measure with the calculations I have.  I had to choose calculated columns.

How can I resolve this to not sum up the values or any other calculation.