Forum Discussion
How to filter out data based on condition
I have data with a snippet shown below, which I have used to make a table visual. Is there a way for me to exclude rows from the visual based on some IF condition? e.g. hide the 2nd row in the screenshot shown below if the value in the 1st row is equal to 1. How about modifying the values of the min/max columns as well? e.g. if 2nd row is equal to 1 then change min and max in 1st row to 1 and 3. If anyone could show me an example of how this could be done that would be very helpful. Thanks
2 Replies
- v-luwang-msft
Community Support
Hi Anonymous ,
Could you pls show me your expect output from the picture you provided?I see in the image you provided, that value value is a decimal, not 1 or 2, when it is a decimal the logic is?
Best Regards
Lucien
Hi v-luwang-msft ,
I showed the wrong data here. Please check my other post at https://community.powerbi.com/t5/Developer/How-to-remove-rows-from-a-dataset-based-on-condition/m-p/2355339
I tried a basic Python script but it did nothing
