Forum Discussion
Help with Matrix chart
- 5 years ago
Hi Anonymous ,
For lines for x, you can create a new line chart and add measure for line for x. Then hide the legend,X-axis and Y-axis title, etc on line chart. Place the two visuals overlapping. Please refer to https://stackoverflow.com/questions/53212642/add-a-dynamic-constant-line-based-on-column-in-powerbi
For lines for y, I really did not find any workaround and alternative custom visual. You may need to create R visual for it: https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-r-visuals
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi Anonymous ,
I'm afraid this couldn't be achieved because the value of constant line is determined by constant value, it can't be changed by slicer.
I also recommend you create an idea for it in https://ideas.powerbi.com/forums/265200-power-bi-ideas to improve the power bi.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
- Anonymous5 years agoNot applicable
Thank you! Using a constant line was just a temporary solution. But I think I am really looking for the right way to show lines for x and y lines ie. these lines need to be dynamic. But thanks for your help. I really appreciate it.