Forum Discussion
Hide text
Hi,
I have a matrix with the last 5 years in column and a measure of satisfaction.
I need to highligh only for year 2020, the measure when the difference with 2019 is significant.
The significant difference is calculation I did in another measure called Significance. I was not able to put the background in green only for 2020.
The measure for all years is impacted... I need that only 2020 background is highlighted and I need to hide the Significance measure.
Can someone help ?
clem312 what you are using in conditional formatting? We need to tweak that measure to include the Year 2020, for example:
Background Color = IF ( <<check significant value>> && SELECTEDVALUE ( YourTable[Yearcolumn] ) = 2020, "Blue" )and use the above measure in condition formatting by selecting field value on conditional formatting dialogue.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
12 Replies
clem312 what you are using in conditional formatting? We need to tweak that measure to include the Year 2020, for example:
Background Color = IF ( <<check significant value>> && SELECTEDVALUE ( YourTable[Yearcolumn] ) = 2020, "Blue" )and use the above measure in condition formatting by selecting field value on conditional formatting dialogue.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
clem312 isn't it 1.95 should have a dot (.) instead of the comma
Background Color = IF ( [Significance]>1.95 && SELECTEDVALUE ( Q74a[Annee_lib] ) = 2020, "Blue" )✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
clem312 make sure the format of your measure is TEXT, I think it is a bug, if you add a measure by default it changes its type to decimal and that's why it is not available to select.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
I put it in text but I cannot select it either :
No it's gry. Only the field make_lib is enabled to click.
It returns True or Blue.
