CODEWITHSUNDEEP
excelpowerbidata-visualizationpowerquerypowerbi-desktop
MmVv
MmVv

Reputation: 553

Power BI: Custom Min/Max values into Visual (Line chart)

I am trying to do some reporting stuff (engineering field), and I am stuck on some "simple" thing, how to insert/add custom Min/Max values so that I can have on the certain visual (like on the picture) border values, min and max that I have defined!

I am receiving set of data, where Min/Max aren't included, and I have to calculate them (those border values are defined by us). I tried to do add column but when I go to "analytics" and try to put there Min/Max, I am getting doubled lines and its quite messy (on pic below)... Is there any easier and better way to calculate / add that? From additional table or else??

Min would be 60 °C

Max would be 100 °C , it is just temperature range and its limitation.

enter image description here

So on the pic below, I tried Add Column into the Data and also Measure directly (60 and 100 degrees) and got this below....the problem is, you cant edit these lines... the thing is I wanted them from Analytics part but there I cant see them because they re not "existing".

enter image description here

Upvotes: 0

Views: 5668

Answers (1)

MmVv
MmVv

Reputation: 553

So, after little bit of playing around and some suggests of PBI pros, I will just write two ways of getting the same results, with minor change.

1) You can insert measure/column into your data set (in my case that was Min = 60 and Max = 100), simple as a day. Then on Format tab > Customize series where you can adjsut your Line: width, type, style...

2) Without any calculation: On Analytics tab > add 2x Constant Lines, put values that you want and thats it.

The only difference here is Data labeling, on 2nd option you can see your limiter value on one of the sides...and using 1st option, your limiter value is through whole line, and you cant remove it (for a whole line). But depends what and how you wanna see your data.

Maybe there are some other ways but this one was fine for me, didnt explore fully PBI yet.

Upvotes: 1

Related Questions