Dear all, I need to customize the colors in various charts. For the area line chart shown in the screenshot, the line is blue, but I want a different fill color from the line color. Is that possible? Additionally, in chart like the donut chart can I change the text color based on conditions? For example, text should be red if below average and green if above. How can I achieve this with conditional formatting?
Also, is there a method to control the visibility of specific visual cards based on row-level security, such that it displays a message like “You are not entitled to view this content” unless access is requested? Also, can the card be hidden completely if there is no data available?
Edit: I also wanted to ask about the conditional formatting in gauge and KPI charts (used as metric cards). Is it possible to make this conditional formatting dynamic, based on calculated fields instead of hard coded value?
For the area line chart, I don’t believe you can change the top line color but you can change the fill color by changing the color of the grouping:
You would not be able to apply conditional formatting to the y-axis text color. To change the text color you would need to use the theme settings and that would affect all text. This also applies to the text color of the center value in the donut chart.
For the RLS error message I recommend checking out the solution from a similar post below:
To hide visuals entirely I would check out this post:
You can use a calculated field to base your conditional formatting on:
