Conditional format Numeric Display

Mike Ryan shared this idea 7 years ago
Completed

Hi there,


It would be really useful if there was a way to apply conditional formatting (ie colour of the number) per the conditional formatting set on the table, like the digital numeric display does.


Let me know if I have missed something and there is a way to do so!


Thanks!

Dani

Replies (8)

photo
1

Hi Dani,


You can definitely color a value based on conditional format rule. See screenshots below and also attached example from Ski Team .

6659234a8193f80f7c939ed4e60e847f

e7c23e5b817dccb033dbf65d71236ac8


Please let me know if I'm missing anything.


Regards,

David

photo
1

Sorry for my lack of explanation, I was referring to the 'Numeric Display' chart type.

photo
1

All good, now I fully understand, and yup you're correct.


I do know this is something we do plan to support in the future, and have linked this idea to that dev task. Any updates on that will be posted here.


However, in the meantime, the digital number chart will display the conditional formats automatically. See screenshot below, and attached report export example based on Ski Team.


a5dc467b94aaf6a8b8dcf5ff77185075

Hope this is a feasible option in the meantime.


Regards,

David

photo
1

Thanks David,


For now I have just created a pie chart (with the conditional formatting) and put a number chart over top which is working for now :)

da8cadf56e6dcc65a7cd3a2a95411bf6


Cheers,

Dani

photo
1

Nice workaround :)

photo
1

Hi Danielle,


Just letting you know this item has now been completed in the latest 7.3 release made available for download today.

Please let us know how it all goes post upgrade.


Thanks,

David

photo
1

Hi,

Can you guide me with conditional formatting on pie chart with ref to Danielle Howes comment above.

Also, I am trying to achieve conditional formatting on numeric display chart type.

Need help on both.

Regards,

Syed

photo
1

Hi Syed,


I'm just closing this out out due to inactivity, but please don't hesitate to reach back out if you require further assistance.

Regards,

Mike

photo
photo
1

Hi Syed,

To get this pie chart look:

-Drag in a Metric to your report builder. Set your desired Conditional Formatting:

a15b330b34802c6f1bfef777a0819183

-Head into Charts > choose Pie > drag Metric into Color and Size > click Series Settings > Color > Conditional Format:

8db5df75f5f626d5d8263b0e4f4d0ddc

23c14903cbecb99c16a3914f1404a381

-You'll then probably want to get ride of the description under the chart, by going Legend > None, also from the Charts stage.

-Then the easiest way to get a number over the chart would be to make it a multi-chart, by clicking the "+" in the bottom right, leaving the second chart blank.

-Head into the Design stage and drag your chart into the canvas and add a text widget and type in the value for the chart:

01d8496657fce59fc16f97bdfb56b99f


To conditionan format the Numeric Display Chart, it's done the same way as above - by going into Series Settings > Color > Conditional Formatting. Except the conditional formatting is a bit limited for this chart type. As you can see applying the conditional fomratting to this chart type looks a bit different:

83d7b20a57d8a84f64210f1f24c013cd

Hope this gives you what you're looking for. Let me know if you have any further questions.

Regards,

Mike

Leave a Comment
 
Attach a file