Plot measure on horizontal bar chart as Y-axis

[pxb015]

Hi, I'm asking for help plotting a measure onto the Y-axis of my horizontal graph in PBI Desktop. Thanks in advance for all responses!

I have a table of dates (for the sake of the example I only care about the month and year), objects with an ID, and a column signifying if each object was "on time". For other reasons this column is either "Y" or null. The table below is an example of what I have.

Date	Object ID	On Time
02/2022	abc	Y
02/2022	def	null
03/2022	ghi	Y
03/2022	jkl	Y
05/2022	mno	null

I also have a measure in my dashboard which counts the percentage of "on time" objects vs total objects. The goal of this measure is so that I can see the total percentage of "on time" objects each month. This is my measure:

PercentCompletedOnTime = FORMAT(ROUND(DIVIDE(Count('Table'[On Time]), Count('Table'[Object ID])), 2), "Percent")

Now my problem: I want to plot the measure onto a horizontal bar chart by month, but PBI won't let me add the measure to anything other than the tooltips.

PBI does allow me to plot the month on the x-axis and the count of object IDs on the y-axis. So I can see total objects each month, good but not what I want. Strangely I'm allowed to add the measure "PercentCompletedOnTime" into the tooltips though. As can be seen in the screenshot below.

So if I hover my mouse over the bar, I can see the measure's value for each month. PBI shows me that it can count the value each month, but it won't actually let me make a bar from it. What am I doing wrong?

What do I need to do to for PBI to allow me to put the "PercentCompletedOnTime" measure into the Y-axis and not the tooltip?

[amitchandak · Accepted solution]

@pxb015 , Create it like

PercentCompletedOnTime = ROUND(DIVIDE(Count('Table'[On Time]), Count('Table'[Object ID])), 2)

and mark it as % measure using measure tool