Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Remove values above a range

I am working with real-time data that I am adding to my Power BI file. Sometimes, some of the values are wrong because they are out of range. So far I replace them manually but I have the question of whether I could program some criteria so that they are automatically eliminated above a certain value.

Need Help

2 Replies

  • AlB's avatar
    AlB
    Community Champion
    6 years ago

    Hi Anonymous 

    Can you show some sample data (in tabular format rather than screen capture) and an example with the expected result?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    HI Anonymous ,

    What real-time datasource you mean, can you please explain more clearly? If you mean streaming dataset, I'd like to suggest you add if statement to check pushed records.
    If you mean live connection mode datasource, you can add filters on 'report level filter'.

    Regards,

    Xiaoxin Sheng