Graph : Selection with Table

[Chandrashekar]

Hello,

When click on company name from table graph should show only company name(Hide rest) and week num(last 3 weeks).

Sample Data 

1. Graph should hide all company other than which is not selected in table

2. shows only last 3 weeks data.

Regards,

Chandrashekar B

[v-zhangti]

Hi, @Chandrashekar 

You can try the following methods.

Measure = IF(SELECTEDVALUE('Calendar'[Week Num])>=WEEKNUM(TODAY())-2,1,0)

Is this the result you expect? Only the last three weeks of data are displayed. Hide company names that are not selected.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Chandrashekar]

Hello,

Thanks for your reply. Is it possbile to hide axis without Slicer(Company Name).

I was looking to interact data between table and graph. i.e. If company selected in Table only that company name should display in Graph.

Regards,

Chandrashekar B

[v-zhangti]

Hi, @Chandrashekar 

Can you picture the output you expect?

Best Regards,

Community Support Team _Charlotte

[Chandrashekar · Accepted solution]

Hello,

Sorry for late reply. I got the solution. We need to turn on filter in graph.