Forum Discussion
conditional format color coding dynamic in power bi
Hello team,
I am new to this community and power bi Dax, I am facing challenges with 2 things -
I have a matrix, part of which needs conditional formatting of a column based on the values of the other measure in the data/table.
I need to color code the actual values in the table based on the upper 10% and lower 10%, which means
- if the actual value is < 10% Plan value then Yellow
- if actual value > 10% upper Plan value then Red
- if actual value >= 10% lower Plan Value and <= 10% Upper Plan Value then Blue
But I am not sure how to apply it to the table, I have created a formula color coding but not sure how to apply it to the table.
2.) question -
I have created a calculated column Data. Type, wherein I have to show UD2 value for 202212, and is available in the data but my formula is not showing it on the table on page 1 not sure what am I missing,
could you please help?
link to the file for reference, sorry couldn't attach the file as I don't see the option
https://1drv.ms/u/s!AggqoJ41P4YMeOJDQyg2vrj5S0w?e=BrpqaK
Thank you in advance.
Hi Zeen ,
According to your description, I download your file and here's my solution.
1.Conditional formatting is for visuals not data table. In the visual formatting pane>Cell elements, turn on the Font color option.
Select the Color Coding column in the dialog.
Get the correct result.
2.According to your formula, in 202212, all rows should be blank except "SIERA FC1 2021" data type, it's correct.
In page1, I change the column Data Type to calculated column Data.Type, not find anything wrong.
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Hi Zeen,
About the color condition, you can apply the formula you created Color Coding following this path below
Regarding to the calculated column, I could not understand what you're expecting to see, could you create some illustration with the difference? Like Actual vs. Expected
Regards,
Douglas.
Hi Zeen ,
According to your description, I download your file and here's my solution.
1.Conditional formatting is for visuals not data table. In the visual formatting pane>Cell elements, turn on the Font color option.
Select the Color Coding column in the dialog.
Get the correct result.
2.According to your formula, in 202212, all rows should be blank except "SIERA FC1 2021" data type, it's correct.
In page1, I change the column Data Type to calculated column Data.Type, not find anything wrong.
I attach my sample below for your reference.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
