Forum Discussion
Filter with conditional
Hi JCarranza24 ,
I created a sample pbix file(see attachment) for you, please check whether that is what you want.
1. You can create a measure as below:
Conditional foramtting =
VAR _minvalue = 0.2 --or the calculated min value
VAR _maxvalue = 0.8 --or the calculated max value
RETURN
SWITCH (
TRUE (),
[Sum of values] < _minvalue, "yellow",
[Sum of values] > _maxvalue, "red"
)2. Make conditional formatting base on
Apply conditional formatting in tables and matrixes
If the above one can't help you get the desired result, please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.
How to upload PBI in Community
Best Regards
Hi Anonymous, I really appreciate your time for helping me, I am sharing with you a simplified PowerBi file and the excel database I use as suggested:
I tried the option you gave and it works but it selects all the elements that follow the min and max values I enter, here on the example I am sharing I can show you what I am trying to do with more detail. On the little table at the bottom, I have the ranges for each element and one of the conditions I would like to be able to filter, and in the bigger table I have all my samples, the filter I was trying to create is like the one in the top; when clicking on each element I would like to have on the bigger table just the samples that are in the correct condition, for example in range, lower limit or upper limit.
I tried creating a custom column for each element using code as below but I cannot get the result I want because if I use these columns to create a filter, it become a mess.
Again thank you very much, I am completely new to this and I appreciate any help and advice.
https://drive.google.com/drive/folders/1SRHiA5tH1Nw9h2KE3yj9dY7JFQ-rPb9X?usp=sharing