Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Giada_Togliatti
Post Patron
Post Patron

color based on a formula in extension bci calendar

Hi,

I'm using the calendar extension: BCI Calendar, I have a field with values from 1 to 1000, I would like to color values from 1 to 50 green, values from 50 to 99,9 orange and values from 100 to 1000 red, how can I do?

Thank you

1 ACCEPTED SOLUTION
v-yangliu-msft
Community Support
Community Support

Hi  @Giada_Togliatti  ,

Are you referring to the custom visual object Beyondsoft Calendar

v-yangliu-msft_0-1620350215695.png

You can find the conditional formatting option in values in Visualizations Format Background.

v-yangliu-msft_1-1620350215702.png

 

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
v-yangliu-msft
Community Support
Community Support

Hi  @Giada_Togliatti  ,

Are you referring to the custom visual object Beyondsoft Calendar

v-yangliu-msft_0-1620350215695.png

You can find the conditional formatting option in values in Visualizations Format Background.

v-yangliu-msft_1-1620350215702.png

 

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yangliu-msft
Community Support
Community Support

Hi  @Giada_Togliatti  ,

According to your description, I create some data:

v-yangliu-msft_0-1620278372368.png

1. I filtered the range of index in Filter, only the data that needs to be used is displayed, which is convenient for viewing the results

2. Select the Index column, select Conditional formatting-Background color

v-yangliu-msft_1-1620278372383.png

3. Enter the Background color interface, select Format by -Rules, and set the rules in Rules as follows:

v-yangliu-msft_2-1620278372388.png

4. Result:

v-yangliu-msft_3-1620278372390.png

 

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-yangliu-msft , thank you for the reply, the problem is that in extension BCI Calendar I don't have the conditional formatting option in values

amitchandak
Super User
Super User

@Giada_Togliatti , Try a new color measure like the example

Switch(true() ,
max(Table[Field]) <=50 , "Green", // or use sum(Table[Field])
max(Table[Field]) <100 , "Orange",
max(Table[Field]) <=1000 , "Red"
)

 

and use that is conditional formatting using "field Value" option

@amitchandak , thank you for the reply, but under data color of this extension BCI Calendae I don't find a conditional formatting option, where is it?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.