Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Show items with no data not working

Hello,

 

I'm doing a table which is supposed to display informations for every days of the week -from Monday to Friday to be precise- and resetting on the week-end. As the table fill up over time, the incoming days are empty (for example, on Monday, the days from Tuesday to Friday are empty).

So, I made a first table like this, which worked fine ; after a few researches, I found the "Show items with no data" option and activated it. By this way, I could get the table I want.

 

...but I had to change some parameters in my table. After rearranging everything and getting working results in the table, I couldn't get again the incoming days, even with "Show items with no datas".

And I can't figure why something which worked before refuse to work now. It's still working in the other file (I cloned the fist file to be sure).

I've wondered if the problem was the new connection I made, because there is no calendar icon in front of Last Updated Date,

but it was already the case for the previous table. And of course, I've checked, Last Updated Date is a date and not another type of datas.

 

So now, I have no idea, and I leave it to you if you have an idea ^^'>

 

Thank you,

Horus

  • Hi Anonymous ,

     

    The Show items with no data feature doesn't have any effect in the following circumstances:

    • There's no measure added to the visual, and the grouping columns come from the same table.
    • Groups are unrelated. Power BI doesn't run queries for visuals that have unrelated groups.
    • The measure is unrelated to any of the groups. In this case, the measure will never be blank for only some group combinations.
    • There's a user-defined measure filter that excludes blank measures. For example: SalesAmount > 0

     

    For more information, please refer to:Show items with no data in Power BI - Power BI | Microsoft Learn

     

    Best regards,

    Yadong Fang

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

1 Reply

  • v-yadongf-msft's avatar
    v-yadongf-msft
    Community Support

    Hi Anonymous ,

     

    The Show items with no data feature doesn't have any effect in the following circumstances:

    • There's no measure added to the visual, and the grouping columns come from the same table.
    • Groups are unrelated. Power BI doesn't run queries for visuals that have unrelated groups.
    • The measure is unrelated to any of the groups. In this case, the measure will never be blank for only some group combinations.
    • There's a user-defined measure filter that excludes blank measures. For example: SalesAmount > 0

     

    For more information, please refer to:Show items with no data in Power BI - Power BI | Microsoft Learn

     

    Best regards,

    Yadong Fang

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