Forum Discussion
constat line with 99 but data changes
hiii want to add a constat line with 99 in the analytics pane to my graph but when i add that to my graph the data changes in the visualization how can i over come and just add a line on my graph
Anonymous what value you are giving to constant line, it should be .99 not (99)
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
3 Replies
- parry2k
Super User
Anonymous what value you are giving to constant line, it should be .99 not (99)
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
- MFelix
Hi Anonymous ,
What do you mean by the graph data changes?
taking into account that your chart is in % the value you must add is 0.99 and not 99
- amitchandak
Anonymous , you can create
measure =.99 and data type decimal and mark as % column. and use that in visual
Other option to explore is analytics pane
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane
