Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

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 ch...
Need Help
  • chrisu's avatar
    chrisu
    10 years ago

    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.

     

     

  • Sean's avatar
    Sean
    10 years ago

    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!

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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:

  1. 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.

  2. 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.

  3. 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".