Forum Discussion
Issues with Conditional Formatting in PowerBi (Format by Rules)
Hi Anonymous ,
Please follow the below steps to achieve your requirement,
1. Create Index column starting with 1 (Can Create in Query Editor)
2. Create a measure as below,
% Index = MIN('Table'[Index])/CALCULATE(COUNT('Table'[Index]),ALL('Table'))3. Place the fields Item,Value,Index,Index% in Table chart and sort asc by Index.4. Create a new column as below,Column = SWITCH(TRUE(),[% Index]>=0 && [% Index]<=0.33,"#C0392B",[% Index]>0.33 && [% Index]<=0.66,"#3498DB",[% Index]>0.66 && [% Index]<=0.99,"#27AE60",[% Index]>0.99,"#F4D03F")5. Do conditional formatting on %Index field as below,Conditional Formatting->background color->format by field vale->choose column filed.See the expected results as below,Please mark it as a solution if this works for you.
Hi Anonymous ,
Thanks. This works amazing for given scenario :).
But there is still a concern related to it, what if my values are unique but have different Index number and hence there is a difference in Index%. I doubt there might be slightest chances for error.
Hey Anonymous ,
As i suspected, this creates a problem if more values are added!
Hi Anonymous ,
Add the Index Column in Query Editor. I am not sure how you have included Index column.
See the below as I have unique values for 3 items biut still they have different index.
Hi Anonymous ,
i did add index colmn using power query editor.
I need all the values with 456 to be conditionally formatted under single color code.
Thanks!