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 selected in table

2. shows only last 3 weeks data.

Regards,

Chandrashekar B

  • Chandrashekar's avatar
    Chandrashekar
    3 years ago

    Hello,

     

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

     

4 Replies

  • 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