Forum Discussion
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 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
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)You can do that as a calculated column, a measure, or as a calculation item in Deneb. Be mindful of the UX.
3 Replies
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)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) ?
You can do that as a calculated column, a measure, or as a calculation item in Deneb. Be mindful of the UX.
