Assistance required to plot a visual

[lavankumar1989a]

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

[SamInogic]

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]

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