Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
106 | |
87 | |
77 | |
69 |
User | Count |
---|---|
124 | |
112 | |
94 | |
84 | |
75 |