Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.
@coolshib ,Put the date(date used in slicer) on the card and use the Last ad Aggregation option.
Where is color grouping here
I am talking about the above dynamic title option.
Best Regards,
Shib
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
User | Count |
---|---|
92 | |
85 | |
76 | |
66 | |
62 |
User | Count |
---|---|
110 | |
96 | |
95 | |
64 | |
57 |