Forum Discussion

ahumke's avatar
ahumke
Icon for Helper I rankHelper I
8 years ago
Solved

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

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

Need Help
  • ahumke's avatar
    ahumke
    8 years ago

    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.

3 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi ahumke

    How do you structure your dataset?

    Which columns do you add to the bullet chart?

     

    Best Regards

    Maggie

    • ahumke's avatar
      ahumke
      Icon for Helper I rankHelper I
      8 years ago

      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's avatar
        ahumke
        Icon for Helper I rankHelper I
        8 years ago

        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.