Is it possible to get alternate font colors on the values in a column based on another column?
Hello d_gosbell , I am currently using Power BI Report Server Desktop (January 2022) Version. I've created this Pivot Table visual. The Table Name of the below is 'Table C'. % column = CALCULATE(DIVIDE(SUM('Table C'[Value2]), SUM('Table C'[Value]),0), ALLEXCEPT('Table C', 'Table C'[ID])) So basically, as shown in the table below, For ID = A, there are 2 categories (10% and 100%), for each category each column has a particular value. In the % column, basically we want to calculate Value2/ Value for both the categories 10% and 100% and show the overall % for this specific ID = A. The same is shown below, The main question is, in this % column, for ID=A, for both categories the overall % value is 1.13, but as we cannot merge the 2 rows in 1 cell. Is it possible to change font colors of alternate values in this % column? We can base it on the condition that in the % column, if the Category = 10%, we can make the font color 'red' and the other category (100%) font color can be 'blue'. Is it possible to do the above, and how? Thanks for your support in advance!
