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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
UsePowerBI
Post Prodigy
Post Prodigy

How to indicate a baseline or a limit in a graph?

Hello

 

I a graph, e.g. bar graph or dial or anything, we want to indicate a value that is a cut-off point or a limit or a baseline. We want this value to be indicated on the graph so that we see whether we have exceeded that or not etc.

 

Is it possible?

 

Thanks!

1 ACCEPTED SOLUTION

Hi , @UsePowerBI 

PBI has already added the ability to create multiple data bound reference lines on some visuals.

When you  create  a  bar chart ,you can create a  constant line  .You can set it in visual analytics  pane.

 

19.png

When you create a dial gauge  ,you can create a  measure to set you target value.

 

20.png

 

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

@UsePowerBI ,You can add create a measure with static value and add

Can you please explain with an example.

Example

Avg line = calculate(Avergae(Table[Value]),All(Table))

Static Line = 10 //New column or measure

 

Hi , @UsePowerBI 

PBI has already added the ability to create multiple data bound reference lines on some visuals.

When you  create  a  bar chart ,you can create a  constant line  .You can set it in visual analytics  pane.

 

19.png

When you create a dial gauge  ,you can create a  measure to set you target value.

 

20.png

 

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.