Forum Discussion

KGBOR's avatar
KGBOR
Icon for Helper I rankHelper I
2 years ago

Missing value with in a drill down option

I came across a very strange issue and I did not find any reasonable explanation for it.

I have a measure which calculates the weekly change of a specific value. Since it is a weekly value, I had to create a separate date hierarchy for it and I put it on a simple line chart. 

 

Now when I use "Expand all down one level in the hierarchy" I don't have week 14 on my chart, however when I use "Go to the next level in hierarchy" I do. I uploaded an earlier week and a later week as well to the dataset and they both appear. Then I uploaded another extract from Week 14 and remove the original one, but I used a different day from that week but week 14 still missing with "Expand all down one level in the hierarchy". 

I have no filters appllied, the data is in the same format consistently and week 14 do appears with "Go to the next level in hierarchy" option. 

Is there any reasonable explanation for this? 

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi  KGBOR ,

     

    Do you have actual data in your data at 14 weeks, if so it will be displayed automatically, if not it will be skipped.

    You can try changing the X-axis - Type - Categorical

     

    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly