Forum Discussion

pitucc's avatar
pitucc
Icon for Helper I rankHelper I
9 years ago

Limit interaction to certain filters

Hello,

In one table,  I have a list with names and many other data. This table is filtered under "Date_histo" and only shows the Names and Datas associated with date_histo = today. 

I have a Line Chart that that print average_price on each date (x = histo_date y = average price ). When I select a name in my table, the Line chart perfectly iflter by "Names= name selected" but also by "date_histo=today" and hence only plot one point instead of historical price for this name. 

 

Any idea if we can keep the interaction but limit it to certain filter ? 

Thanks in advance,

Cheers

Pierre

 

 

Need Help

9 Replies

  • v-caliao-msft's avatar
    v-caliao-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    pitucc,

     

    I have tested it on my local environment, we cannot reproduce this issue. The sample PBIX for you reference.

     

    If the issue persists, please share us the PBIX file, so that we can make further analysis.

     

    Regards,

    Charlie Liao

    • pitucc's avatar
      pitucc
      Icon for Helper I rankHelper I
      9 years ago

      Hi Charlie,

      Thanks for your answer, unfortunatly you did not have the same issue because you have used a slicer instead of a Table (i don't know how to atteche a pbix file....) 

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi pitucc

         

        Did you try to make an independent time dimension and connect your data with the purpose of using the dates in the time dimension as x-axis?

         

        Best,

        Martin