Forum Discussion
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...
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.
Nithinr
Resolver III
Resolver IIIyou can use edit interation feature in power bi. Anonymous
To use edit interaction i must insert a slicer in the report. In my case i have to use the filter panel