Restricting data

[Anonymous]

Hi Experts,

At modelling level

my transaction table contains flag(1....10) , i want to set flag=1 at data level , Is it possible to restrict  at modelling/transformation level,

At report level

If i use report filter , when ever i click bookmark value, its removed the filter

[amitchandak]

If you go and filter data in the edit query or transform data model, That will not be available for data analysis.

also refer :https://community.powerbi.com/t5/Desktop/Filtering-data-in-Edit-Queries-not-the-same-as-using-slicer...

[Anonymous]

i just need to pick all the data where flag=1, is there any way we can restrict it in report level.

i tried to apply page filter , but i have bookmark selection which unselected the filter.

[amitchandak]

Refer :https://www.tutorialgateway.org/power-bi-report-level-filters/

[amitchandak]

Other way is on the Data view the table icon left. On the Home tab you have the option to transform data.

Click on column and filter value. Save and close. Only filtered value for analysis