Forum Discussion
Coming chart issue
Hello experts,
i need help in finding solution or workaround for an issue.
so I have a cluster column line chart where x axis is text type, left Y axis for column is amount in thpusands ranging from 0 to 1500 K, right Y axis for line is % ranging 0 to 100%.
Now, baseline data came as a new field and as amount in K and it should be added as line in same chart.
how do I accomplish that? Number for baseline is 900 k. How can I add a flat horizontal line at 900 k?
thanks a lot,
12 Replies
Hi Anonymous ,
can you provide sample data and a screenshot?
Maybe a constant line can be used?
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane
Thanks. In combo chart, there is nothing in analytics pane.
sample data looks like below:
Date. Text. Amt. %. Baseline
01012017. 1st of year. 1000. 30. 900
12312016. End last year. 700. 20. 900
X axis text, y left axis for column amount, y right axis %, tooltip date.
howdo I put baseline date as a horizontal line which is amount data?
thanks