Forum Discussion

jurgenvd's avatar
jurgenvd
Helper I
9 years ago

how Items with no data issue with filter

 

 Hello Everyone

 

There is a problem with the active filters if you select "Show items with no data"

 

below an example that shows tickets created per month, 

When i select "Show items with no data" it displays more than 14 months ago than the relative slicer is saying.

What is also strange is that the graph also shows months that are still about to come.

Anyone with similar issues, is this a bug?

 

many Thanks

 

 

 

 

 

 

  

Need Help

11 Replies

  • vanessafvg's avatar
    vanessafvg
    Community Champion
    9 years ago

    jurgenvd 

     

    if you want to show blank data based on your relative filter i woud suggest using

     

    if(isblank(measure), 0, measure)

     

    what is your current measure? and what are you trying to do?

    • jurgenvd's avatar
      jurgenvd
      Helper I
      9 years ago

      vanessafvg

       

      Hi

       

      i can not use the if Isblank meassure since there is nothing to measure.

      If no ticket is created in a specific month, than i will not find that date back in my table.

       

      Or am i wrong?

       

      Thanks for you help! 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Gi jurgenvd

     

    Can you tell me about, what you've plotted in your visualization? And if those columns comes from the same table. I think we need some more information to solve your challenge.

     

    Best,

    Martin

     

     

    • jurgenvd's avatar
      jurgenvd
      Helper I
      9 years ago

      Anonymous

      Hi  

      This is how i build my graph 

       

      Axis : "ticket creation date"

      Value: count of ticket-number

       

      Relative slicer "Last 14 Calendar Months"

       

      If i unselect the "show items with no data" option than it shows correctly the last 14 Calendar months.

       

      Thanks for your help

       

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee
        9 years ago

        Hi jurgenvd,

        After research, I can not reproduce your issue. Do you mind share your .pbix file for further analysis?

        Best Regards,
        Angelia

  • jurgenvd's avatar
    jurgenvd
    Helper I
    9 years ago

    Something extra that i found is that my graph is only showing the data of the last 14 months,  but the months before and after he still keeps showing with no data.

  • TomMartens's avatar
    TomMartens
    Super User
    9 years ago

    Hey,

     

    sometimes I encounter the same issue.

     

    This happens, if I'm choosing different sources for the date slicer and the bar chart.

    Choosing a date column from a separate Calendar table (it's always a good idea to have a separate date table) for the sllicer and the data column from your table where the meausre is located, will result in disparate visualization.

     

    Maybe you can check if the source for both of your visualiztions is based on the same column

     

    Hope this helps