Forum Discussion

shteff24's avatar
shteff24
New Member
1 year ago
Solved

Show Items with no data

Hi! I've got a report with a table filled with data. I am trying to create a slicer for a date type of data. The slicer is supposed to let me choose a year and a month to see all the transactions from that period. However the slicer adds the months and years with no data as well. 

I have tried enabling and disabling the Show Items with no data option but nothing happened.

Is there a way to get rid of all the years where I have no data registered?

 

Need Help
  • PBIViz_2024's avatar
    PBIViz_2024
    1 year ago

    Hi,

     

    You can achive this by using a dax measure as below.

    filtermeasure = INT ( NOT ISEMPTY (Table1)).Here Table1 is the table with data.Create this measure and put this to the filter pane do as below.

    Regards,

2 Replies

  • PBIViz_2024's avatar
    PBIViz_2024
    Advocate I
    1 year ago

    Hi,

     

    You can achive this by using a dax measure as below.

    filtermeasure = INT ( NOT ISEMPTY (Table1)).Here Table1 is the table with data.Create this measure and put this to the filter pane do as below.

    Regards,

  • danextian's avatar
    danextian
    Super User
    1 year ago

    Hi shteff24 

    Slicers behave differently.

    I am assuming you're using a date column from a calendar table. Create a measure that counts the number of rows in the fact table and use that as a visual filter.

    Fact Table Row Count = 
COUNTROWS(Data)