Forum Discussion

TITO22's avatar
TITO22
Frequent Visitor
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, TITO22 

     

    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, TITO22 
TITO22 

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

see below image

 

TITO22's avatar
TITO22
Frequent Visitor
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, TITO22 

     

    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