Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
hemingt
Helper V
Helper V

How to filter values in the table

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.

360-25836718.jpg

 

 

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

2.PNG

 

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

7 REPLIES 7
v-frfei-msft
Community Support
Community Support

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
    )

Capture.PNG

 

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

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.

 

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
    )

2.PNG

 

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

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

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

aoliver
Helper III
Helper III

Hello

 

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

 

 

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.

 

Anyone who can give some advice? thank you!

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.