Assistance required to plot a visual

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,

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!