Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Stage movement visualization

Dear All,   I have to create a visualization to display the stage movements of two compared years. I have the CP (=Current Period) Loan and PP(=Previous Period) Loan tables and they are connected ...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    5 years ago

    Dear v-robertq-msft ,

    Thank you for your inputs! 
    In the meantime, I have merged PP and CP tables and based on this, I have created the following visualization:

    This is more or less the solution I'd like to achieve.

    Thanks and regards,

v-robertq-msft's avatar
v-robertq-msft
Community Support
5 years ago

Hi, Anonymous 

According to your description and sample picture, I think that the scatter chart in the Power BI can roughly meet your requirement, but you have to replace the value “not present” in the column [1_Stage 2018] to 0 because the Y-Axis of the scatter chart can only support the number type:

 

More info about the scatter chart in the Power BI

 

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result so that we can help you in advance.

How to Get Your Question Answered Quickly 

Thank you very much!

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.