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.
マトリックスにおける、セルの色付けを制御したいと考えています。
例えば上記の表では、以下のような色付けをしたいです。
①行・列のカラム名が一致する場合は〇色(緑色など)にする
②同じ行の中で、左のセルよりも大きい値の場合は〇色にする
セルではありませんが、可能であればグリッド線の色の制御もしたいと考えています。
③指定した境界線のみ〇色にする(例:行「20万~」列「30万~」の境界線)
よろしくお願いいたします。
Solved! Go to Solution.
Hi @masaro1209 ,
All of the conditional formatting in the 'Conditional Formatting' section can be applied to matrices.
Conditional formatting of matrices
The results of the conditional formatting of the matrix benefit values are shown in the following screen print. Remember, however, that only fields in the values well, i.e. measures, can be conditionally formatted.
Matrix - conditional formatting
To learn more details ,refer:
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
Hi @masaro1209 ,
All of the conditional formatting in the 'Conditional Formatting' section can be applied to matrices.
Conditional formatting of matrices
The results of the conditional formatting of the matrix benefit values are shown in the following screen print. Remember, however, that only fields in the values well, i.e. measures, can be conditionally formatted.
Matrix - conditional formatting
To learn more details ,refer:
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |