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 fro...
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,

danextian's avatar
danextian
Icon for Super User rankSuper 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)