I want to connect table to slicer only, otherwise show nothing, is that possible?

[Anonymous]

Hi guys,

I have a table and slicer like below

everything went well but I want to connect the table to slicer only, so if the slicer has no choise so show nothing in the table.

because the defaulte case ( I mean without any selection in the slicer) all the data will show in the table, I do not want that.

I want table enabled just when I select any option in the slicer

Thank you guys,

[PaulDBrown · Accepted solution]

This is how.

1) Create the independent table (no relationships in the model) using the equivalent to the following (select "New table" under Modeling in the ribbon)

IndSlicer Department = DISTINCT('Table'[Department])

The model will then resemble this:

2) Create the following measure (it doesn't matter in which table you create it):

Filter Table =
IF (
    ISFILTERED ( 'IndSlicer Department'[Department] ),
    COUNTROWS (
        INTERSECT (
            VALUES ( 'Table'[Department] ),
            VALUES ( 'IndSlicer Department'[Department] )
        )
    )
)

3) Create a silcer using the field from the Independent Slicer table. Select the table visual and add the [Filter table] measure to the filters in the filter pane for the visual and set the values to greater or equal to 1

[PaulDBrown · Accepted solution]

I don't think you can round that. When you select All, it behaves the same as if you select nothing (in other words the default for no selection is All)

[PaulDBrown]

You could try using an independent  table for the Department slicer (let's call this table IndSlicer)

Create a measure along the lines of:

Fiter table =

IF(ISFILTERED (IndSlicer), 

COUNTROWS (INTERSECT(VALUES(Table[Department]), VALUES(IndSlicer[Department]))))

Select the table visual and add the measure as a filter in the filter pane and set the value to greater or equal to 1

[Anonymous]

Thank you so much Paul,

can you please simplify this part :

---

@PaulDBrown wrote:

You could try using an independent  table for the Department slicer (let's call this table IndSlicer)

---

Do you mean a new query or new table in the Power BI page?

and the measure you want me to create, in which table?

---

@PaulDBrown wrote:

Select the table visual and add the measure as a filter in the filter pane and set the value to greater or equal to 1

---

I dont understand this part, where is filter pane you mentioned?

[PaulDBrown · Accepted solution]

This is how.

1) Create the independent table (no relationships in the model) using the equivalent to the following (select "New table" under Modeling in the ribbon)

IndSlicer Department = DISTINCT('Table'[Department])

The model will then resemble this:

2) Create the following measure (it doesn't matter in which table you create it):

Filter Table =
IF (
    ISFILTERED ( 'IndSlicer Department'[Department] ),
    COUNTROWS (
        INTERSECT (
            VALUES ( 'Table'[Department] ),
            VALUES ( 'IndSlicer Department'[Department] )
        )
    )
)

3) Create a silcer using the field from the Independent Slicer table. Select the table visual and add the [Filter table] measure to the filters in the filter pane for the visual and set the values to greater or equal to 1

[Anonymous]

Amazing Paul

I really thank you so much

last question

everything went right but when I select "All selection" it show nothing