Forum Discussion
Table visual edit interaction for values to change and keep all lines while using slicer
- 6 years ago
Hi Cado_one ,
The "Measure" I used means the measures of yours. You could select columns from your original table to create a new table as a slicer with SELECTCOLUMNS() function. This new table will be independent, so it will not filter your orginal table directly. Then use ALLSELECTED() function to get the range you want to compare.
Thanks for the time tou take to help me. But I still don't make the match between 'Table', 'Measure' and my amount of measures and tables.
In the measure 2 v-eachen-msft , does your [Measure] refer to amitchandak measure in the last post or one of my measures ? And I have difficulties to see how my "new table as a slicer dimension" should be.
Sorry for lagging behind but my english is quiet bad and I'm a newbbie in Power BI
Thanks
Cado
Hi Cado_one ,
The "Measure" I used means the measures of yours. You could select columns from your original table to create a new table as a slicer with SELECTCOLUMNS() function. This new table will be independent, so it will not filter your orginal table directly. Then use ALLSELECTED() function to get the range you want to compare.
- Cado_one6 years ago
Resolver III
Thank you for your help, I finally managed by doing a copy of my data table as you said for the slicer and create a relation between the 2 "Tracker" columns. No need of a new measure.
Have a nice weekend !