Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
dannytan1112
Helper I
Helper I

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?

dannytan1112_0-1672035730488.png

 

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

2 ACCEPTED SOLUTIONS
lbendlin
Super User
Super User

While you could fudge this with an appropriately prepared background image

lbendlin_0-1672097780901.png

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

 

lbendlin_1-1672100427145.pnglbendlin_2-1672100477635.png

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_3-1672101423641.png

 

View solution in original post

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

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

While you could fudge this with an appropriately prepared background image

lbendlin_0-1672097780901.png

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

 

lbendlin_1-1672100427145.pnglbendlin_2-1672100477635.png

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_3-1672101423641.png

 

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors