Forum Discussion
Adding Upper and Lower Limit in a Line Chart
Your values are in different orders of magnitude. Are you planning to only allow the report user to choose a single tag?
Yes they are in different magnitude. But, some are in the same magnitude for example, 55AIA075 pH of Cooling Water Return and 55AIA076 pH of Cooling Water Supply. That is why I use slicer to select any tag in the chart. Let say I want to view pH of both of them ONLY in the chart, I would select 55AIA075 and 55AIA076.
Here is my progress so far.
In addition, I also want to see their trend against the Lower & Upper Limit. Each TAG has their own Lower & Upper Limit. For example for 55AIA075, 55AIA075LL=4.5 and 55AIA075HH=7. How do I make it possible where I can select 55AIA075 in the slicer and the chart will show the trendline, Lower Limit, and Upper Limit for the 55AIA075? Maybe I could attach the relevant files for you to take a look at. I forgot to include in the Excel file, the Lower Limit is in the Column F, and Upper Limit is in the Column G. https://1drv.ms/u/c/f073b93ac622488c/EQjuHvHwFgRNhcpKtI_xSKQBeKFoHwFK4HqX2FkCg5uOgQ?e=7uCniD
Keep working on your data model. Eliminate bidirectionals, add a proper calendar table.
By the way, you can consider using the analytical functions like "constant Y axis line"