Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |