TABLE CELL COLOR

[former_member808777]

Hi everyone,

I filled the table cells with some colours. My problem is that when a new month is automatically added (as I have the date dimension in column) the new cell is not painted.

I need a solution so that when a new month appears, the cells are automatically painted.

Can someone help me?

Thanks.
Martina

[N1kh1l · Accepted solution]

martyss

Select your table and Go to the designer tab and then Styling. Create a Styling rule as shown below. Please Note the Level for Date is set to All which means all date members will be colored. You can adjust this value as per your needs.

Output: Initially only Q1 was added to table

New Months Added. Q2 is added color is still blue.

Please upvote/Accept this helps.

Regards

Nikhil

[former_member808777 · Accepted solution]

Hi Nikhil,

thanks a lot!

Martina

[N1kh1l · Accepted solution]

martyss

Please close the thread by accepting the answer if this answered your question. This will help others looking for a similar issue.

Regards

Nikhil

[abeera11 · Accepted solution]

I've a similar case. But I'm trying to set the color for closed (previous) months with measure value = 1 to red. And for open (current and next) months with measure value set to 2 to green color. How can I do this in the table? I've only been able to set the red value. But I want to set Red for Open/closed month = 1 and Green for Open/closed month = 2

screenshot-2023-08-18-170029.jpg

screenshot-2023-08-18-170115.jpg

[N1kh1l · Accepted solution]

abeera11

You need to use thresholds for that as its a conditional formatting based on measure value

Nikhil

[abeera11 · Accepted solution]

I've applied conditional formatting. But it only changes the color of the measure values, not the whole cell color

screenshot-2023-08-18-175445.jpg

[N1kh1l · Accepted solution]

abeera11

In the Styling panel for the table for thresholds style color background option select as below

It will result as below

Hope this helps !!

PLease upvote if this helps you

Nikhil

[abeera11 · Accepted solution]

Thankyou! Got it.

[sandip_kumar003]

Hi,

You can select the measure column and go to the designer tab,

you can select Styling rules and define the style.

Best Regards,

Sandip Kumar.