Forum Discussion

klehar's avatar
klehar
Helper V
1 year ago

Data not available

Hi, Please see the image below. I have some data for december. But january data is not available yet.  So im hardocding it in the return statement saying   if(isblank(result),0, result) Is the...
Need Help
klehar's avatar
klehar
Helper V
1 year ago

In my date table I have 4 values, included 202502 feb as well against which there is not even a 0entry in the fact table

danextian's avatar
danextian
Super User
1 year ago

Apply ALLEXCEPT to your dates table. I applied that a different table because no sample data was provided and whipped up something for the sake of illustration. Also, your showing 0% in your viz so apply ALLEXCEPT to the same measure as that that is measure you'll want to apply dynamic format string to.

  • klehar's avatar
    klehar
    Helper V
    1 year ago

    it doesnt work on feb that has no data (not even 0)

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi klehar , hello all, thank you for your prompt reply!

      I could not reproduce your issue with the date dimension table, please check the update pbix:

       

      Best regards,

      Joyce

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