Forum Discussion
Empty table with a slicer
Is it possible to have a an empty table unless a specific slicer item is chosen? In other words, if a slicer item is not chosen, nothing in the table will apear, and then when a specific slicer is chosen only the specified information for that particular slicer shows up?
Thanks
I recently attempted to answer that in this discussion.
Basically you need a separate measure that evaluates whether a slicer item is chosen, then use that as a visual-level filter in the table. Something like:
SlicerCheck = =if(calculate(distinctcount([SlicerColumn]),allselected([SlicerColumn]))=1,"Y","N")
Then user SlicerCheck as a visual level filter for the table and set it to show values when SlicerCheck is Y.
Anonymous Yes you can do this however the table/matrix column names will always show!
I also suggest using a slightly different Measure to address what KumarDarmesh asks in the Post referenced by chrisu
Test Measure = IF ( ISFILTERED(Table[Column]), BLANK(), 50 )
Drag Test Measure to the The Visual Level Filter => select Show items when the value: is blank => hit Apply filter
The 50 is just a random number could be anything you choose!
6 Replies
I recently attempted to answer that in this discussion.
Basically you need a separate measure that evaluates whether a slicer item is chosen, then use that as a visual-level filter in the table. Something like:
SlicerCheck = =if(calculate(distinctcount([SlicerColumn]),allselected([SlicerColumn]))=1,"Y","N")
Then user SlicerCheck as a visual level filter for the table and set it to show values when SlicerCheck is Y.
Anonymous Yes you can do this however the table/matrix column names will always show!
I also suggest using a slightly different Measure to address what KumarDarmesh asks in the Post referenced by chrisu
Test Measure = IF ( ISFILTERED(Table[Column]), BLANK(), 50 )
Drag Test Measure to the The Visual Level Filter => select Show items when the value: is blank => hit Apply filter
The 50 is just a random number could be anything you choose!
Hey Sean, I ended up using Anonymous's suggestion (you referenced this suggestion in a related topic here) since it gets to the issue of making ONE selection. If there are multiple boxes checked, the slicer check is N. These solutions are very clever. Tom
To show a blank table in a Power BI visual when no data is selected through cross-filtering, you can create a measure that returns a blank value when no filters are applied. Here's a step-by-step guide:
Create a Measure:
Go to the "Modeling" tab and click on "New Measure".
Use the following DAX formula to create the measure:
BlankMeasure = IF( ISFILTERED('YourTable'[YourColumn]), 1, BLANK() )Replace 'YourTable'[YourColumn] with the actual table and column you are using for filtering.
Add the Measure to Your Table Visual:
- Add this measure to your table visual.
- Set a filter on this measure to show only rows where the measure equals 1.
Adjust the Visual:
- Go to the "Filters" pane.
- Drag the BlankMeasure to the "Filters on this visual" section.
- Set the filter condition to "is not blank".