create area chart with green and red colors to indicate profit and loss
I have created area chart that that shows profit and loss % over time. I would like to show the loss (negative part) in red color and the profit ( positive part) in geen color. i created 2 measures one for profit % and one for loss % positive p&l = var pl=[p&l %] var result= IF(pl>0 , pl,0) return result negative p&l = var pl=[p&l %] var result= IF(pl<0 , pl,0) return result when i added the measures in the chart it looked like: any idea on how to create the area chart with green/red colors instead of 1 color
PBIRS Scheduled Refresh Frequency Setting
Hello, I need assistance with the following use cases for scheduled refresh and specific questions: I have some users who are wanting to schedule their reports to refresh as frequently as every 5-15 minutes. I'm concerned as more and more users will be doing this and eventually add extra burden on the server. The default frequency is wide opened so users can choose to refresh every 1 minute if they wanted to. Is there a way to change the default frequency setting and restrict it to only allow users to select every 30 minutes (as an example)? From what I read so far, custom refresh frequency is not supported, but I want to check if that is the case with PBIRS. Thanks in advance for your assistance.
