Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello PowerBI Community!
I have a matrix with Countries as values and timeline (year, quarters) as columns. I want to color the countries that have end date before 14/12/2023 and keep countries names as texts in values. Could anyone help me with it?
I want to have something like this but colors behind the text:
Thank you!
Solved! Go to Solution.
You can base conditional formatting on the measure that is not in the matrix.
For example, you can create flag measure as:
Date flag = if(max('Table'[Date]) < date(2023,12,31),1,0)
And use it's result for the rule of conditional formatting:
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
You can base conditional formatting on the measure that is not in the matrix.
For example, you can create flag measure as:
Date flag = if(max('Table'[Date]) < date(2023,12,31),1,0)
And use it's result for the rule of conditional formatting:
The pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
User | Count |
---|---|
89 | |
73 | |
69 | |
65 | |
57 |
User | Count |
---|---|
97 | |
92 | |
85 | |
74 | |
68 |