topic Re: Graph : Selection with Table in DAX Commands and Tips

Graph : Selection with Table

Chandrashekar — Thu, 22 Dec 2022 09:25:01 GMT

Hello,

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

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 — Fri, 23 Dec 2022 02:42:16 GMT

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 — Fri, 23 Dec 2022 04:02:25 GMT

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 — Mon, 26 Dec 2022 04:26:06 GMT

Can you picture the output you expect?

Best Regards,

Community Support Team _Charlotte

Chandrashekar — Mon, 26 Dec 2022 14:17:36 GMT

Hello,

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