Forum Discussion

Icon for Resolver I rank

Resolver I

9 years ago

Same stores filter - dynamic column in table?

Hi there, I would appreciate any ideas or help on the following case: I have a table with tickets, in which sales are registered with date, amount and the store where the sale was made. This tabl...

Icon for Microsoft Employee rank

Microsoft Employee

9 years ago

Hi alexvc,

For your requirement, it's impossible. Calculate columns/tables are computed during database processing(e.g. data refresh) and then stored in the model, they do not response to user selections on the report. More details, please see the following knowledge base.

Calculated Column/Table Change Dynamically According to Slicer Selection in the Report.

Best Regards,
Angelia

alexvc
Resolver I
9 years ago
Thanks for the reply Angelia, do you know any way I could trigger a filter (even at page level) upon a slicer change in the report? I'm basically trying to make a new slicer for "same stores" or "all stores", but this attribute depends on the dates chosen in a date slicer

Thanks

Alex
- v-huizhn-msft
  Microsoft Employee
  9 years ago
  Hi alexvc,
  
  Here is a case, the report changes dynamically according to the choice in slicer, please review it and check if it is useful.
  
  Best Regards,
  Angelia
  - v-huizhn-msft
    Microsoft Employee
    9 years ago
    Hi alexvc,
    
    Have your resolved your issue? If you have not, please post some sample data for further analysis. So that I can post solution which is close to your requirement. If you have, please mark the helpful reply as answer, or welcome to share your solution. Thanks for understanding.
    
    Thanks,
    Angelia
- Anonymous
  Not applicable
  7 years ago
  Hi Alex,
  
  Have you found a solution to this problem. I'm facing the same issue