Forum Discussion

Chandrashekar's avatar
Chandrashekar
Resolver III
3 years ago
Solved

Graph : Selection with Table

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 sel...
  • Chandrashekar's avatar
    Chandrashekar
    3 years ago

    Hello,

     

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

     

v-zhangti's avatar
v-zhangti
Community Support
3 years ago

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's avatar
Chandrashekar
Resolver III
3 years ago

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's avatar
    v-zhangti
    Community Support
    3 years ago

    Hi, Chandrashekar 

     

    Can you picture the output you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    • Chandrashekar's avatar
      Chandrashekar
      Resolver III
      3 years ago

      Hello,

       

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