Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Dynamic table based on selected value

I've slicer period: data like Month-year 

 

I've created a table

Param = {
("NBI Adjusted Calendar 2 " , NAMEOF('Fact Performance Indicators'[NBI Adjusted]), 0,"NBI Adjusted","Net Banking Income",0),
("NBI Adjusted Calendar 2", NAMEOF('Fact Performance Indicators'[NBI Adjusted 2]), 1,"NBI Adjusted","Net Banking Income",1))
 
I'd like to display "NBI Adjusted" selectedvalue(period), but it dosen't work,it always return NBI adjusted and not NBI adjusted Oct-2022, how can I change it please?

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable

      I don't think so..

  • amitchandak is correct. Calculated tables cannot be dynamically responsive to slicers since they are only computed once each time the data model is loaded or refreshed and not in response to user interactions via filters/slicers/cross-filtering.

     

    There may be ways to accomplish the effect you're after but you'll need a different approach (I can't tell what you're asking well enough to suggest something specific though).

    • Anonymous's avatar
      Anonymous
      Not applicable

      AlexisOlson Could you please help me to resolve it? I use field parameter.