Night and Day plot area background

[dannytan1112]

Hi There,

I have a question that i can do in Excel however I am having difficulties on doing it in Power BI. 
Is there anyway to make plot area background like this in Power BI?

I would like to make data from 6pm-6am as black bar chart background and the rest data as white bar chart background indicating day time data. Thanks

[lbendlin · Accepted solution]

While you could fudge this with an appropriately prepared background image

this might be the perfect opportunity to try out a custom visual generator like Charticulator or Deneb.

If you want "Day/Night" boundaries you could modify the calculated column like 

BG = if(hour('System Counters'[AggregationEndTimeUTC])>17 || hour('System Counters'[AggregationEndTimeUTC])<6 ,100,0)

[lbendlin · Accepted solution]

While you could fudge this with an appropriately prepared background image

this might be the perfect opportunity to try out a custom visual generator like Charticulator or Deneb.

If you want "Day/Night" boundaries you could modify the calculated column like 

BG = if(hour('System Counters'[AggregationEndTimeUTC])>17 || hour('System Counters'[AggregationEndTimeUTC])<6 ,100,0)

[dannytan1112]

Really Really thanks. it works for me.

Btw i have question, is it possible to make that 100 value in BG became variable?

Let say max value of a column in Table(x) ?

[lbendlin · Accepted solution]

You can do that as a calculated column, a measure, or as a calculation item in Deneb. Be mindful of the UX.