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 i'm trying to get some conditional formatting to work in Bi i already know what the conditions will be but i'm not sure how i can get it working over in BI.
is there anythig that can come close to what i would want it to be in excel?
Solved! Go to Solution.
Hi @Jayfemi,
In the field context menu select the conditional formatting Color Scales then just add the definitions you need, be aware that this is a very simple conditional formatting (believe that will grow) but you can also use some distinct ways to make it work in intervals using measure or something like that.
Below see and example of one column with positive and negative numbers and other that I calculated with intervals of those to add an additional level of colour (interval between -5 and 5).
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsRegards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @Jayfemi,
In the field context menu select the conditional formatting Color Scales then just add the definitions you need, be aware that this is a very simple conditional formatting (believe that will grow) but you can also use some distinct ways to make it work in intervals using measure or something like that.
Below see and example of one column with positive and negative numbers and other that I calculated with intervals of those to add an additional level of colour (interval between -5 and 5).
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering 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 |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |