Need help on using conditional formatting of a column header in Matrix table

[coolshib]

Dear All,

Need help on using conditional formatting in title text of a column header based on field in a matrix table.

I am able to use the conditional formatting in title text based on field in other visualisations like chart, card etc.

Also need help on how to show the last date of a selected date range in a card.

Thanks in advance.

Best Regards,

Shib

[v-alq-msft]

Hi, @coolshib 

Based on my research, It is unavailable to use the conditional formatting in title text based on field in a matrix visual currently.

About how to  show the last date of a selected date range in a card, I created data to reproduce your scenario..

Calendar:

Calendar = CALENDAR(DATE(2019,1,1),DATE(2019,12,31))

You may create a measure like below.

Result = 
CALCULATE(
    MAX('Calendar'[Date]),
    ALLSELECTED('Calendar')
)

Result:

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@coolshib ,Put the date(date used in slicer) on the card and use the Last ad Aggregation option.

Where is color grouping here

[az38]

@coolshib 

just interesting to understand completely your question.

How were you able to get Title conditional formatting in chart visual?

[coolshib]

I am talking about the above dynamic title option.

Best Regards,

Shib

[az38]

@coolshib 

it is a title for whole visual. matrix visual title has the same option.

but you need formatting for Column header according your first post? 

[coolshib]

@az38 

You are right, it is a title for whole visual.

I am looking for the same option for Column header in Matrix table.

Best Regards,

Shib

[az38]

So, @coolshib 

I do not see any option in any built-in table/matrix visuals to change Column header format by conditions, unfortunately

[coolshib]

@az38 

Thank you so much for your reply.

Best Regards,

Shib