Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am trying to build a report to show product volumn and yield, and also KPI. the volumn bar uses first axis which is 0 - 2000, and the yield line using second one which is 70% - 100%, how can I show a KPI line which is 1500. thanks.
Solved! Go to Solution.
Try switching vol and yield around. So use yield for columns and vol for line
Proud to be a Super User!
@ValtteriN thanks, but I need to show volumn bar as well, then the KPI can not be together with yield.
You can still place the column bar values here. I just used two line measures in my example
Proud to be a Super User!
Hi, I put vol and yield, this is good.
how ever, it changed when I tried to put KPI, since the KPI is 1200, it is using same axis with yield. not sure if there is something wrong.
Try switching vol and yield around. So use yield for columns and vol for line
Proud to be a Super User!
Hi,
There isn't a direct option for a constant line like for example in line chart, but you can create a measure like this:
Ping me with @ IF you have questions.
I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!
My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/
Proud to be a Super User!
User | Count |
---|---|
106 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |