Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.