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.