Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Freeze table even if filter used

Hi everyone, I have a table of sales :  I created two table visualisation : sales by month / sales sum by product and month  Now, i want to freeze my left table even if i use the month...
Need Help
  • v-zhangti's avatar
    v-zhangti
    2 years ago

    Hi, Anonymous 

     

    You can try the following methods.

    New table = VALUES('Table'[MONTH])

    Measure = CALCULATE(SUM('Table'[SALES]),FILTER(ALL('Table'),[MONTH]=SELECTEDVALUE('New table'[MONTH])))

    This visual will not interact with the source table.

    Is this the result you expect? Please see the attached document.

     

    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.

Dangar332's avatar
Dangar332
Icon for Resident Rockstar rankResident Rockstar
2 years ago

Hi, Anonymous 
Anonymous 

use visual level filter for second table only(sales sum by product and month )

see below image

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    The expected result is to have multiple tables (4,5...) in the report. Si i can't use a filter for each table. I have to use the page level filter

    • Dangar332's avatar
      Dangar332
      Icon for Resident Rockstar rankResident Rockstar
      2 years ago

      Hi, Anonymous 

       

      you cannot control the interaction with filter pane. page level filter will filter all the visuals on that page.

       

      my suggestion is create a new calculated table for that column which you want to show in visuals is not affected by page level filter .

      not connect that table with data model

       

      refer below link for same problem Link 1  ,Link 2