Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

Slicer Only Relevant Values

Hello, I have combined the main table to the date reference table to get the Fiscal Date Period using Many to One. However, the slicer of the fiscal period includes all date values from the date...

Need Help

Show and Tell

jdbuchanan71
5 years ago
Anonymous

You can write a simple measure to count the rows in your main table, something like.

Data Count = COUNTROWS ( 'Your Table Name Here' )

Then you assign that as a filter on your slicer and set it to 'is not blank' and click apply.