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 with the Stage, as you can see it:

Stage can be 1,2,3. 

My problem is that there are "new" and "gone" loans, so the one that did not exist in the previous period and the one that existed previously, but not in the current period.

 

My aim is to create some visualization like this:

Where you can see the stage movement in every relation.

 

The problem is that with the current relationship, the rows can not find each other and the error message comes up.

If I change the relationship's Cross filter direction to "both" (I can do it on only one of them), at least it shows the values in the diagonal, so where 1->1, 2->2, 3->3.

 

Could you suggest me a solution to get this visualization, please?

Please note, this will be a template, so users will load the different datasets from a server. 

 

Thanks

  • 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,

3 Replies

  • v-robertq-msft's avatar
    v-robertq-msft
    Community Support

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

      Hi, Anonymous 

      Glad to hear that you have solved your problem by yourself, would you like to mark your own reply as a solution so that others can learn from it too?

      Thanks in advance!

      How to Get Your Question Answered Quickly 

       

      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.