I need to conditionally format the last 2 columns in the table below (Open Seats and Pipeline).
Since I am using 'Measure Names' on the column shelf, it seems I am not able to conditional format only the measure values I want. Or is it possible? When I apply the conditional formatting calculation it colors the entire table.
Hi ,
we can do this by creating a dummy calculation field.
create a calculation named zero and give 0 in calculation box. and now drag this filed into columns make the duplicateof this on columns with respect to your measure names. And you will get those many axes. so now go to mark cards and set your desired colur by dropping that particular measure name into color and measure value into label after that slect the mark type as square. after that select the mark type one more time to text .
now hide the header of the zero.
for your understanding iam attaching a screen shot:
Thank you! Can I send the workbook to your email?
Derrick Austin, do you have any insights on this?
Hi Tharashasank Davuluru! I sent you the file via email. Let me know if you have any suggestions on how I should proceed. Thank you!
Hello,
Did you find a solution to this issue? It seems very familiar to one I am currently having.
Thank you,
Anna
Anna Warrington , let me know if you are still looking for a solution. It's best if you can share your workbook. Thanks!