Forum Discussion

lavankumar1989a's avatar
lavankumar1989a
Helper II
2 years ago

Assistance required to plot a visual

Hi experts,

 

there is a requirement that we received from client to plot visuals like below,

Requirement should be like "Product Importance and Competitor Relevance are collapsed into a single overall rating for the vertical axis.  The horizonal axis is a computed value based on status and age from filing"

 

So please find and do let me know if we can plot the same type of visual splits. So please share any sample pbix file, will helps me a lot if you came across with same requirement. 

 

Thank you so much in advance for your support!

 

Thanks

 

Need Help

2 Replies

  • SamInogic's avatar
    SamInogic
    Super User
    2 years ago

    Hi,

     

    You can utilize the Power BI Visuals like Bubble / Scatter Chart and Packed Bubble,

     

    You can get it from More Visual in Power Bi Desktop

     

     

     

    We have a sample table with two Custom Column in Power BI Desktop

     

     

     

    Please find the Table and column structure below,

     

    ID

    Type

    Week

    Label

    ProductImportance

    CompetitorRelevance

    Status

    AgeFromFiling

    1

    A

    W1

    Y

    4

    3

    IDF

    1

    2

    A

    W1

    Y

    5

    4

    IDF

    3

    3

    B

    W1

    Y

    2

    2

    App

    6

    4

    B

    W2

    Y

    3

    3

    App

    8

    5

    B

    W2

    N

    1

    1

    IDF

    10

    6

    C

    W2

    N

    2

    2

    IDF

    12

    7

    B

    W3

    Y

    3

    4

    App

    15

    8

    C

    W3

    Y

    5

    5

    IDF

    18

    9

    A

    W3

    N

    4

    4

    IDF

    20

    10

    B

    W4

    Y

    2

    3

    App

    7

     

     

    Create a calculated column that combines ProductImportance and CompetitorRelevance.

     

    OverallRating =

    ('Sample Product'[ProductImportance] + 'Table'[CompetitorRelevance]) / 2

     

    Create a calculated column based on Status and AgeFromFiling.

     

    HorizontalValue =

    SWITCH(

        TRUE(),

    'Sample Product'[Status] = "IDF" && 'Sample Product'[AgeFromFiling] <= 5, 1,

        'Sample Product'[Status] = "App" && 'Sample Product'[AgeFromFiling] <= 5, 2,

        'Sample Product'[Status] = "IDF" && 'Sample Product'[AgeFromFiling] > 5 && 'Sample Product'[AgeFromFiling] <= 10, 3,

        'Sample Product'[Status] = "App" && 'Sample Product'[AgeFromFiling] > 5 && 'Sample Product'[AgeFromFiling] <= 10, 4,

        'Sample Product'[Status] = "IDF" && 'Sample Product'[AgeFromFiling] > 10 && 'Sample Product'[AgeFromFiling] <= 15, 5,

        'Sample Product'[Status] = "App" && 'Sample Product'[AgeFromFiling] > 10 && 'Sample Product'[AgeFromFiling] <= 15, 6,

        'Sample Product'[Status] = "IDF" && 'Sample Product'[AgeFromFiling] > 15 && 'Sample Product'[AgeFromFiling] <= 20, 7,

        'Sample Product'[Status] = "App" && 'Sample Product'[AgeFromFiling] > 15 && 'Sample Product'[AgeFromFiling] <= 20, 8,  

      BLANK()

    )

     

    Hope this helps.

     

    Thanks!

     

    • lavankumar1989a's avatar
      lavankumar1989a
      Helper II
      2 years ago

      Hi SamInogic ,

       

      Thanks for your response and sharing the info. But we are looking in a bubble need to show different splits like below, highlited in red color

      within a single bubble customer is looking spilt like above. So if this would be possible can you please share the details along with a sample pbix file please to incorporate into my design.

       

      Thank you so much for your kind support and help!

       

       

      Thanks,

      Lavan