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.
Hi,
is it possible to set conditional formatting based on other field value when the based field is a calculated column?
tried to do the setup, but i couldn't clicked on the calculated column.
Solved! Go to Solution.
Color formatting by Field value requires a color field in your data model. It can either be a existing field, or a calculated column or a calculated measure.
But in your case, you can use Conditional Formatting by Rules (instead of by Field). Check the latest feature released with June update.
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-june-2019-feature-summary/#containerColors
Hi @RMV ,
Is possible to set the colour based on a measure you need to have the measure return the colour code you need based on this type of format:
Measure = SWITCH ( TRUE (); SUM ( Table1[Target] ) = 1; "#F2C80F"; SUM ( Table1[Target] ) = 4; "#5F6B6D"; SUM ( Table1[Target] ) = 5; "#000000" )
In my case I'm making the check of the column, but you can do a switch based on a value from another column or measure, and define each interval as shown.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @RMV ,
Is possible to set the colour based on a measure you need to have the measure return the colour code you need based on this type of format:
Measure = SWITCH ( TRUE (); SUM ( Table1[Target] ) = 1; "#F2C80F"; SUM ( Table1[Target] ) = 4; "#5F6B6D"; SUM ( Table1[Target] ) = 5; "#000000" )
In my case I'm making the check of the column, but you can do a switch based on a value from another column or measure, and define each interval as shown.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThanks all for the guidance.
I kinda used a bit of this and that, considering the measured column I used limited the setup of the conditional formatting based on field.
I have to create a variance field and added it up to the table, and set the conditional formatting in this field, instead.
yea, it's a measure.
thanks for the correction.
too bad it's not allowed.
is there any possible workaround?
Depends on your case.
You may use a calculated column.
Thanks
A
Color formatting by Field value requires a color field in your data model. It can either be a existing field, or a calculated column or a calculated measure.
But in your case, you can use Conditional Formatting by Rules (instead of by Field). Check the latest feature released with June update.
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-june-2019-feature-summary/#containerColors
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |