How to filter values in the table

[hemingt]

Hi,

Here is my data source excel, https://1drv.ms/x/s!AsM9bO8zGUN6qnXhW_xy3NskH3jT

and my pbix file, https://1drv.ms/u/s!AsM9bO8zGUN6qncapG3qHuDHI0ce

I create two measures, Outgoing and InComing. and show the stacked columns chart with these two measures.

I aslo create a table to display source data on the same page.

I want to show the data in the table according to the chart, that is to say, I click somewhere on the chart, the table only show the related data. Do you have any suggestion?

I also upload the snapshot what I created.

[v-frfei-msft]

Hi @hemingt ,

Create a measure as below and make the table visual filtered by the measure.

Measure =
VAR _sele =
    SELECTEDVALUE ( Sheet1[Week] )
RETURN
    IF (
        MAX ( Sheet2[Create_Week] ) <= _sele
            && MAX ( Sheet2[Close_Week] ) >= _sele,
        1,
        0
    )

Regards,

Frank

[hemingt]

Hi @v-frfei-msft ,

Thank you very much for your help.

it seems the solution did not work.

Please see your uploaded snapshot.

you click the week 1908 column, in the right table, those issues which Close_Week or Create_Week not equal 1908 displayed.

it should only display the Close_Week =1908 or Create_Week =1908.

what's more, if I click the red part of week 1908 column, right table should only display the Create_Week = 1908.

[v-frfei-msft · Accepted solution]

Hi @hemingt ,

We can update the meausre to get the result as below.

Measure = 
VAR _sele =
    SELECTEDVALUE ( Sheet1[Week] )
RETURN
    IF (
        MAX ( Sheet2[Create_Week] ) = _sele
            || MAX ( Sheet2[Close_Week] ) = _sele,
        1,
        0
    )

what's more, if I click the red part of week 1908 column, right table should only display the Create_Week = 1908.

---

For the request, we cannot achieve that here.

Regards,

Frank

[hemingt]

thank you for your great help @v-frfei-msft 

[aoliver]

Hello

You mean that you dont want the table be updated when you click in some column?

[hemingt]

Hi @aoliver ,

I want to the table refresh the data according to the click on the chart,

such as,

if I click on the Outgoing on the Week 1902, then only issues of Close_Week = 1902  displayed in the table,

if I click on the InComing on the Week 1902, then only issues of Create_Week = 1902  displayed in the table.

[hemingt]

Anyone who can give some advice? thank you!