Forum Discussion

goyalsa's avatar
goyalsa
Helper III
5 years ago
Solved

show blank value in matrix

Hi All,

I am not able to get the week that has a blank value. I already try to select "show items with no data" but still the same result.

Thanks in advance!!

 

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi goyalsa 

    I tried to build measures to filter the visual or change the code, but due to relationship, it is not a good way to achieve your goal.

    Here I suggest to use filter in Loadingweek in Filter Field manually. If you select 202130 in slicer, enter 202130 in filter as below. Result will start from 202130.

    Best Regards,
    Rico Zhou

     

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

20 Replies

  • APavlovs's avatar
    APavlovs
    Resolver II
    5 years ago

    Hi goyalsa Have you created a Date table? If you have created just a new column from the original dataset then my guess is that it does not have any reference to weeks that don`t have any data.

     

    If you create a Date Table you can use that as the date dimension and it will include all the weeks with BLANK values.

     

    Basic sample here - https://files.fm/u/vcrmuytne

     

     

    Did I answer your question? Mark my post as a solution ğŸ™‚

    • goyalsa's avatar
      goyalsa
      Helper III
      5 years ago

      Hi APavlovs,

       

      I have created a Date table and made a relation with the other table (Loading week).

       

      The column headers show the loading week from the Date table, and the rows show the status from another table.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Hi goyalsa 

        I agree with APavlovs 's reply. Add YearWeek from your Date table instead of YearWeek from your Fact table. Then use show items with no data.

        First visual use YearWeek from Date table and second visual use YearWeek from Fact table.

        Best Regards,
        Rico Zhou

         

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

  • APavlovs's avatar
    APavlovs
    Resolver II
    5 years ago

    Any chance you could add a sample.pbix that way it will be easier to debug the situation.

     

     

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        5 years ago

        Hi,

        In another post, you mentioned that you have created a Date Table - i do not see that in your PBI file.  Please create that Table, ensure that you have a Date table in Table1 as well.  Also, in the Date Table, also create a Week number and Year column.  Share the download link of the revised PBI file.

  • mussaenda's avatar
    mussaenda
    Community Champion
    5 years ago

    Hi goyalsa ,

     

    You need a date table, create a relationship to your fact table

    then use the data from the date table to the matrix.

     

    Hope this helps.

  • APavlovs's avatar
    APavlovs
    Resolver II
    5 years ago

    goyalsa Do you have a Date column in the original table? Might be the relatioship since its Many to Many right now.

    • goyalsa's avatar
      goyalsa
      Helper III
      5 years ago

      In the original table, I have the loading week, week forecast filled in.