Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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)
You can do that as a calculated column, a measure, or as a calculation item in Deneb. Be mindful of the UX.
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.