help with a work around solution? Maybe DAX table in report?

[ahumke]

I have a YOY measure using DAX with a filter for year to select only one year for a bullet chart KPI.  It will display fine in a table but in the bullet chart it seems to ignore the year filter.  I submitted the issue to Microsoft but in the mean time, I am looking for a work around.  I was thinking possibly a DAX table that includes only the 2018 year I want to display could work but I haven't been able to get DAX syntax to work in this fashion.  Open to any ideas.

Sample Dashboard

[v-juanli-msft]

Hi @ahumke

How do you structure your dataset?

Which columns do you add to the bullet chart?

Best Regards

Maggie

[ahumke]

Here are links to the files:

Excel

PBIX

The bullet chart has a catgory of 'Program Title', then the YOYComletions measure - there are two but neither works.  One of them simply makes it so "Infinity" doesn't display.  Then the other fields are markers to drive the color change.  

[ahumke · Accepted solution]

Follow up - I was able to fix this by creating a DAX date table.  Then I had to create a new field in the DAX table that was derived with a string formation of the date - "1/1/" & [Year].  Then that has to be converted to a date form.  For some reason that is the only version of the field that plays well with the bullet chart.  I did try that same process within my original data table but it wasn't working (I think because it wasn't continuous - but also because the heirarchy kept automatically getting put on it).  Sorry I don't really understand why this worked or why it was necessary - but it is resolved for now.