Forum Discussion

dannytan1112's avatar
dannytan1112
Helper I
3 years ago
Solved

Night and Day plot area background

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 woul...
  • lbendlin's avatar
    lbendlin
    3 years ago

    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's avatar
    lbendlin
    3 years ago

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

lbendlin's avatar
lbendlin
Super User
3 years ago

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's avatar
dannytan1112
Helper I
3 years ago

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's avatar
    lbendlin
    Super User
    3 years ago

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