topic Re: Night and Day plot area background in Custom Visuals Development Discussion

Night and Day plot area background

dannytan1112 — Mon, 26 Dec 2022 06:23:03 GMT

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

Re: Night and Day plot area background

lbendlin — Tue, 27 Dec 2022 00:37:06 GMT

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)

Re: Night and Day plot area background

dannytan1112 — Tue, 27 Dec 2022 07:22:58 GMT

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) ?

Re: Night and Day plot area background

lbendlin — Tue, 27 Dec 2022 12:26:03 GMT

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